Topics

• InputBox
• Getting started with excel-vba
• Getting started with VBA
• Declaring Variables
• Scripting.FileSystemObject
• VBA Best Practices
• Procedure Calls
• Common Mistakes
• Flow control structures
• Comments
• Excel VBA Tips and Tricks
• Conditional Compilation
• VBA Option Keyword
• Creating a Custom Class
• Getting started with excel-formula
• Working With Files and Directories Without Using FileSystemObject
• Operators
• VBA Run-Time Errors
• Creating a drop-down menu in the Active Worksheet with a Combo Box

Examples

• Use InputBox to assign user input to a string
• Accessing the Visual Basic Editor in Microsoft Office
• First Module and Hello World
• Use VB constants when available
• Select Case
• Using xlVeryHidden Sheets
• Avoid using SELECT or ACTIVATE
• Enumerate files in a directory using FileSystemObject
• Always define and set references to all Workbooks and Sheets
• Changing code behavior at compile time
• ActiveWorkbook vs. ThisWorkbook
• WorksheetFunction object executes faster than a UDF equivalent
• Option Explicit
• Option Compare {Binary | Text | Database}
• Option Base {0 | 1}
• Debugging
• Declaring Fixed-Length Strings
• Optional Arguments
• Introduction
• Bitwise \ Logical Operators
• Example 2: Options Not Included