Course Duration & Prices
Our VBA course is delivered onsite at your own offices over 2 days. These would ideally be two consecutive days, however they could be spread over a week or more if necessary.
Our Microsoft VBA group training rates are as follows (prices are for 2 days):
- 1 – 3 delegates: £1000
- 4 – 6 delegates: £1100
- 7 – 10 delegates: £1200
- Above 10 delegates: £1200 + £120pp
Please note that these are the total costs per group, not per delegate. For example, if you have 10 employees to put on to a course, you can see that the cost per person equates to just £120. All rates are + VAT. Laptops can also be supplied where required for a small daily rate of £15 each.
VBA 2 Day Training Course
The course includes:
Getting Started with Excel VBA
- Why use Excel VBA?
- Recording a Macro
- Assigning a Macro to a Button
- Saving as a Macro Enabled Workbook
- Recording V’s Coding
- The Visual Basic Editor Environment
- Navigating between Excel and the VB Editor
Editing Code + Methods of Executing
- Structure of a Sub Routine
- Writing your First Code
- Executing a Sub Routine/Macro
- Break Mode
- Using Macro Comments
Visual Basic Language Rules
- The Object Model Hierarchy
- Properties and Methods
- Active Objects
- Using Inbuilt Functions
- Adjust VBE Settings
- Working with Variables
Control Structures
- IF, Nested IF
- AND OR NOT
- SELECT CASE
Looping Structures
- Do Loops
- For Next Loops
- For Each Next Loops
Interactive Macros
- Using a Msgbox
- Use a Conditional Message Box
- Use the Inputbox
Create Interactive Forms
- Create a User form for Data Entry
- Build Form Controls
- Use of the Properties Window
- Build a Dialog Box
Using Events
- What are Event Procedures?
- Workbook Events
- Sheet Events
- Form Control Events
- The On Time event