Excel VBA
Delivered Face to Face or Virtually
Who should attend?
This interactive; hands-on course has been designed for people who wish to learn the essentials of Microsoft Excel VBA programming language; and how to setup and use the main concepts and methods of VBA programming; and understand the relevant techniques.
Prerequisites
Delegates should have a good knowledge and understanding of Microsoft Excel to a high level. Familiarity with the content of the Level 2 course would be a minimum requirement.
Course Objectives
The course is designed for existing; experienced users who need to use Microsoft Excel VBA to automate their spreadsheets.
This course can be customised to incorporate other features of Office 365.
To find out more about our training options or to find out whether this course is right for you, please speak to our team today.
Course Duration
1 Day Classroom Training or Online.
Our course timings are 09:30 - 16:30, however timings can be customised to meet your needs.
Recording Macros
Recording a Simple Macro
Running a Recorded Macro
Relative Recording
Viewing the Module
Modifying a Recorded Macro
Learning the limitations of Macro Recording
Visual Basic Editor
Using the Project Explorer
Using the Properties Window
Creating, Importing and Exporting Modules
Explore Recorded Macros
Running Procedures from the Editor
Setting Break Points in the Editor
Stepping through a Procedure.
Understanding VBA
Using the Immediate Window
Working with Object Collections
Setting Property Values
Working with Worksheets
Using the Object Browser
Programming with the Object Browser
Procedures
Creating a Procedure
Making sense of IntelliSense
Using the Edit Toolbar
Commenting Statements
Indenting Text
Bookmarking in Procedures
Using Excel Objects
The Excel Object Model
Splitting the Screen
Using Workbook Objects
Using Worksheet Objects
Using Range Objects
Using Objects in a Procedure
Using Variables
Implicit and Explicit Declarations
The scope of Variables
Procedure Level Scoping
Module and Public Level Scoping
Passing Variables
Avoiding Variant Data Types
Using Arrays
Programming Techniques
Programming Conventions
Communicating with the User
Prompting for User Input
Using the Input Method
Using IF to Make Decisions
Testing for Multiple Conditions
Looping Specified and Non-specified Amount of Times
Creating Custom Forms
Creating a Custom Form
Changing the Form Properties
Adding Text Boxes to the Form
Moving and Adding Controls
Changing Label Control Properties
Adding a Combo Box
Adding Option Buttons
Adding Command Buttons
Running a Form
Programming Custom Forms
Initialising the Form
Closing the Form
Updating the List
Creating Error Handling Procedures
Running a Form from a Procedure
Sharing Workbooks
Programming Automatic Events
Running Automatic Procedures
Automatically starting the a Workbook
