3. VBA Guide

• 3.1. 10min - VBA Starter Kit
  • 3.1.1. Initial Set-Up
  • 3.1.2. Running your first script
  • 3.1.3. Introduction to Data Variables
  • 3.1.4. Expanding on your first script (Pt. 1)
  • 3.1.5. Introduction to Objects, Properties, and Methods
  • 3.1.6. Expanding on your first script (Pt. 2)
• 3.2. builtin - Class Modules
  • 3.2.1. Member Variables
  • 3.2.2. Properties
  • 3.2.3. Methods
  • 3.2.4. Events
• 3.3. builtin - Enumerations
  • 3.3.1. Enum Statement
  • 3.3.2. Enumerations as Arguments
• 3.4. builtin - Runtime Errors
  • 3.4.1. Validation Errors
  • 3.4.2. Clean Ups
• 3.5. builtin - Events
  • 3.5.1. Turning Events On/Off
  • 3.5.2. Event Optimization
• 3.6. builtin- Interapplication Control
  • 3.6.1. Early Binding vs. Late Binding
  • 3.6.2. Setting An Application Instance
  • 3.6.3. Example #1: Sending an Outlook Email
  • 3.6.4. Example #2: Exporting an Access Table or Query to Excel
• 3.7. builtin - Logic Loops
  • 3.7.1. True False
  • 3.7.2. If ElseIf Else
  • 3.7.3. Select Case
  • 3.7.4. For Loops
  • 3.7.5. Do Loops
  • 3.7.6. Looping Through Files in a Folder
• 3.8. builtin - Subroutines and Functions
  • 3.8.1. Input Arguments
  • 3.8.2. Optional Arguments
• 3.9. Tips and Tricks
  • 3.9.1. Named Ranges
  • 3.9.2. Calculations, Events, and Screen Updating
  • 3.9.3. R1C1 Reference Style
• 3.10. access - Database Management Systems
  • 3.10.1. Access Objects
  • 3.10.2. Access from Excel
• 3.11. excel - Concatenate Multiple
• 3.12. excel - Cell Split
• 3.13. excel - Buffer Data From .csv Without Opening
• 3.14. office - Create Outlook Email
• 3.15. office - Hidden Window Background Check