Course Content (2 days - 2 Participants)
- Introduction and Need for VBA
- 1.1. Advantages & Disadvantages of VBA
- 1.2. Macros for automation
- 1.3. User-Defined Functions
- Interface & Structure
- 2.1. Settings – Developer Tab, Macro Security,File types
- 2.2. Macro Recorder
- 2.3. VB Editor & Components
- Sub procedures & Function procedures
- 3.1. Subs versus Functions
- 3.2. Executing Sub procedures
- 3.3. Executing Function procedures
- VBA Language Elements
- 4.1. Variables, Constants & Data Types
- 4.2. Assignment Statements
- 4.3. Using Labels
- Program Flow and Logic
- 5.1. Declaring Variables
- 5.2. Flow Control Structures
- 5.3. Looping
- Events
- 6.1. Triggering the code – Events
- 6.2. Event-handling Procedures
- 6.2.1. Worksheet-level events
- 6.2.2. Workbook-level events
- Error Handling & Debugging
- 7.1. Run-time Errors
- 7.2. The “On Error” Statement
- 7.2.1. On Error GoTo label
- 7.2.2. On Error Resume Next
- 7.2.3. On Error GoTo 0
- 7.3. The “Resume” Statement
- 7.3.1. Resume
- 7.3.2. Resume Next
- 7.3.3. Resume label
- 7.4. Debugging
- 7.4.1. Types of bugs
- 7.4.2. Debugging Techniques
- Interacting with Users
- 8.1. Need for and various ways of user interaction
- 8.2. Simple dialog boxes – MsgBox and InputBox functions
- 8.3. Other built-in dialog boxes –GetOpenFileName method,GetSaveAsFilename method, FileDialog object, Application.Dialogs
- Working with Add-ins
- 9.1. Need for Add-Ins
- 9.2. Creating, opening / enabling, and modifying Add-Ins
- 9.3. Sharing your code
