Topics

• Getting started with excel-vba
• Declaring Variables
• User Defined Functions (UDFs)
• VBA Best Practices
• Excel VBA Tips and Tricks
• Scripting.Dictionary object
• Binding
• VBA Option Keyword

Examples

• Switch off properties during macro execution
• Using xlVeryHidden Sheets
• Worksheet .Name, .Index or .CodeName
• Always define and set references to all Workbooks and Sheets
• Properties and Methods
• Avoid re-purposing the names of Properties or Methods as your variables
• Allow full column references without penalty
• Option Explicit
• Option Base {0 | 1}
• When to use a Static variable