This Visual Basic for Applications (VBA) training
course is designed to give a good working knowledge of using
Visual Basic with Microsoft Excel.
The VBA content of the training course
can be applied to other Microsoft Applications.
Delegates should have attended the Advanced
Excel Course and
have a good understanding of Excel functions and templates.
Click here for a printable version of Excel Visual Basic Course
Outlines
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
|
