Date/Time
Date(s) - 16/09/2022
All Day
Location
Glasgow Training Centre
Categories
This Introduction to Excel VBA training course covers:
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
Debugging and Error Trapping
- What are Errors?
- Types of Error
- Break Mode
- Instant Watch
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
- Toolbars and Display