 |
|
Course Contents
- Creating Record Macros
- Recording a Macro
- Running a Macro
- Running a Macro from the Macros Dialog Box
- Creating a Short-cut key to run a macro
- Running a Macro with a Shortcut key
- Assigning a Macro to a Menu or Toolbar
- Editing a Macro with Visual Basic
- Visual Basic Editor
- Objects
- Methods
- Properties
- Programming Tools
- The Menu Bar
- Running Code
- Run mode and Design mode
- Running Code from the development environment
- Running Code from the host application
- The Project Explorer
- Using the Project Explorer
- The Properties Window
- Changing a Property
- Using Constants
- Excel Constants
- Variable Constants
- Excel Objects
- Objects, Properties and Methods
- Getting & Setting Properties
- Calling Methods
- Passing Arguments
- Singular Objects & Collections of Objects
- Variables
- Dimensioning a variable
- Using variables in routines
- Object Variables
- Using Visual Basic Functions
- InputBox Function
- MsgBox Function
- Using a Set Statement
- Building Formulae Control Structures
- If…Then Decision Structures
- Logical Operators
- Select Case Decision Structures
- Case Else
- Comparison Operators with Select Case Structure
- For… Loops
- Do Loops
- While...Wend Statement
- UserForms
- Designing & Creating Forms
- Working with Controls
- Creating Custom Dialog Boxes
- Userform Properties Methods & Events
- Event Handling
- VBA Editing & Debugging
- Auto Macros
- Error Handling
|
|
|
|
