Recording Macros
- Record Absolute and Relative Macros
- Assign Marcos to a Button
User Defined Functions
- Create a Custom Function to Perform a Calculation
- Call a Function from a Worksheet
- Call a Function from a Macro
Using Visual Basic Editor
- Visual Basic for Applications
- Working with Objects, Properties, Methods, and Events
- Use the Immediate window
- Understand the Object Model
- Using the Object Browser
Programming basics
- Working with data
- Using Variables
- Understanding Scope
|
Controlling program flow
- Using Decision Structures
- Using Loop Structures and their Variations
Working with custom dialog boxes
- Creating custom dialog boxes (Userforms)
- Handling events
- Programming Custom Dialog Boxes
Automatic Startup
- Create a Macro to Run Automatically on Start up
Custom Menus
- Create a Custom Menu for a Project
- Customise the Menu System
Debugging and error-handling
- Errors in Code
- Using Debugging Techniques
- Error-handling
|