Microsoft Access VBA
Sponsored links
This two-day Microsoft Excel VBA course takes you through Visual Basic for Applications in Excel from recording macros through to advanced form design. On the way you will learn how to write object-oriented programs and how to create loops and implement error-handling.
You should be an advanced user of Excel and ideally have attended Intermediate and Advanced level courses before attending this training.
| Delivery: |
|
| Category: |
Further Details
Automating Everyday Tasks
How Visual Basic for Applications talks to Microsoft Excel
Creating a simple macro
Recording and editing macros
Stepping through a macro
Relative and absolute recording
Assembling a project from multiple macros.
Introduction to Excel VBA
Recording a macro in Excel
Running a macro
Editing a macro
Overview of Visual Basic Editor
Creating modules
Project window
Properties window
Inputs and Outputs
Selecting cells, ranges and objects
Entering formulas and calculations
Input and message boxes
Variables
Assigning data to variables
Declaring variables
Data types
Variable scope
Constants
Using option explicit
Control Structures
If, then, select case, do, while, for and for each
Objects, Properties, Methods, Events and Error Handling
Capturing errors
Manipulating errors
Debugging
Quick watch (for variables)
Break points
Debug window
Forms (dialog boxes)
Command buttons
Comboboxes (dropdowns)
Tick boxes
Radio buttons
Form initialisation
Menus and toolbars
Building custom menus
Modifying the standard toolbars
Creating custom tools & toolbars
Optional Extras (if required)
Event triggered procedures
Creating add-in applications
Links to other applications
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Contents © 1999 - 2012. All rights reserved.
