This course explores the VBA language and delegates will be encouraged to record, edit, write and test Macros to ensure that future editing can be carried out with the minimum of effort. This is a hands-on course where delegates will practice what they learn during the course.
Introduction
* What is a Macro
* Recording & Running a Macro
* Relative verus Absolote Code References
Assigning Macros to Buttons and Objects
* Assigning a Macro to a Button or a Drawn Object on a Sheet
* Assigning a Macro to a Button on a Toolbar
* Customising a Toolbar
* Creating a Toolbar
* Button Image Editor
* Changing a Button's Screen Tip
Editing Macros
* Visual Basic Editor
* Project Explorer
* Procedures; Inserting Comments
* Printing a Visual Basic Module
The Range Object
* Cells & Range Method; Flexible Ranges
* Virtual Worksheets; Range Contents
Workbooks and Sheets
* Activating a Workbook
* Activating a Worksheet
Control Structures
* Conditional & Looping Control Structures
* Sub Procedures
Storing Information
* Using InputBox
* Using MsgBox
Debugging & Error trapping
* Errors Stepping & Error Handling
Worksheet & Workbook Events
* Worksheet Object Events
* Workbook Object Events
Function Procedures
* Creating User Defined Functions
