Category: [Excel]  Demo Available 

---

Microsoft Excel Frequently Asked Questions and Answers Page 2 of 3

Got any Excel/VBA Questions? Excel Help

This list of Excel frequently asked questions and answers is ever growing.

1	Auto-Run-Macros
2	Excel AutoFilters in VBA using Dates
3	Criteria for VBA filters
4	Excel VBA AutoFilters
5	2 Criteria VLookup for Excel
6	3 Criteria VLookup for Excel
7	4 Criteria VLookup for Excel
8	5 Criteria Vlookup for Excel
9	Excel 2007 Alternative To File Search
10	Add Excel Worksheets in Month/Monthly Order
11	Add Excel Worksheets in Numeric Sequence
12	Add Worksheets to Excel via VBA
13	Find Feature to Find 3 Matching Criteria in 3 Columns in Excel
14	List/Return Difference Between 2 Cells Containing Comma Separated Strings
15	Use Array Elements To Fill a Range With Headings
16	Automatically Add Date, Time or Date & Time
17	Display Excel AutoFilter Criteria
18	Use AutoFilter in Excel VBA to Filter by Date & Time
19	Speed up Excel VBA Macro Code
20	Functions To Determine Excel Calculation Status & Mode
21	Change Text to Upper Case or Proper Case
22	Color or Format a Formula Referenced Cells - Precedents
23	Copy Multiple Column & Row Records Into Single Row Records
24	Loop Through Controls on a UserForm
25	Convert a String or Number to Boolean
26	Convert a String to a Byte Data Type
27	Convert to a Currency Data Type
28	Convert to a Date Data Type
29	Convert to a Decimal Data Type
30	Convert to a Double Data Type
31	Convert to a Integer Data Type
32	Excel VBA: Convert to a Long Data Type
33	Convert to a Single Data Type
34	Convert to a String Data Type
35	Convert Excel Text To Upper Case
36	Convert Numbers to Words/Text
37	Excel VBA: Convert to a Variant Data Type
38	Count Or Sum Specified Number In a Single Cell
39	VBA Count of Each Item in a List
40	Count Distinct Values Once/Count Repeated Entries Only One Time
41	Custom Excel Function (UDF) that will Count Words in Excel
42	Create a Worksheet Calendar
43	Excel: Convert Currency Number to Words/Text
44	Examples & Usage Of Excel VBA Custom Functions
45	Add Quick Access to Excel Custom Lists
46	Create Custom Menu Items in Excel VBA
47	Cursor Movement Shortcut Keys
49	Add/Subtract Dates In Excel VBA
50	Debug Excel VBA Macro Code

 

See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets

 

Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.

 

 

Gallery

---

• 
• 
• 
• 
• 
•