Visual Basic
Introduction to Macros
- What is a Macro?
- Recording a Macro
- Running a Macro
- Relative References
- Assigning a Macro to a Button on a Worksheet
- Assigning a Macro to a Button on a Toolbar
- Button Image Editor
Editing Macros
- The Visual Basic Editor
- The Project Explorer
- The Code Window
- Procedures
- Inserting Comments
- Printing a Visual Basic Module
- The Range Object
- What is the Range Object?
- The Cells Property
- The Range Property
- Flexible Ranges
- Range Contents
Workbooks and Sheets
- Activating a Workbook
- Activating a Worksheet
- ThisWorkBook
- Calling Worksheet Events
- Calling Workbook Events
Debugging and Error Trapping
- What are Errors?
- Types of Error
- Break Mode
- Instant Watch
- Stepping Through Code
- Error Handling Worksheet and Workbook Events
- Creating Line Labels for Error Handling
- Writing Error Handling Code to Trap Errors
- Error Handling to Resolve Errors
- Resuming after Resolved Errors
Objects, Properties and Methods
- Controlling Objects with their Properties
- Performing Actions with Methods
- Performing Multiple Actions on an Object
Variables and Constants Control Structures
- Conditional Control Structures
- Looping Control Structures
- Non-Structured Statements
- Subprocedures
Controls, Dialogue Boxes and Forms
- Built-In Dialogue Boxes
- Predefined Dialogue Boxes
- Custom Forms
- Worksheet Forms
- Setting the Properties of a Control
- User-Defined Forms
- Adding Form Controls
- Form Control Properties
- Control and Dialogue Box Events
- Displaying and Dismissing a User Form
- Handling Form Controls
Toolbars and Display
- Customising the Quick Access Toolbar
- Customising the Ribbon
- Using Worksheet Buttons
Function Procedures
- Function Procedures
- User-Defined Functions
- Function Wizard
- Excel Functions
Add-in Applications
- What is an Add-in?
- Creating an Add-In
- Working with Excel Add-Ins
This course is a two day course but can be condensed in to a 1 day session.