Microsoft Excel Frequently Asked Questions and Answers Page 2 of 3

< Back to Search results

 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
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.




stars (0 Reviews)