
This event has passed.

Excel VBA Level 1
August 28, 2018 - August 29, 2018
| £295Microsoft Excel 2007-2016 VBA Level 1
Duration
2 Day
Prerequisites
Delegates should have a good working knowledge of Excel and ideally have attended our Excel level 3 course. However, no programming knowledge is assumed.
Course Type
Instructor-led hands on training with all delegates using a computer
Course Objectives
To enable delegates to record, edit and write their own macros to automate spreadsheets and understand the programming concepts and environment of Excel Visual Basic for Applications.
Course Content
Understanding Visual Basics
- Recording Absolute/Relative Macros
- Editing Macros
- Introduction to the Visual Basic Editor
- Adding comments
- Enabling/Disabling lines of Code
- The Excel Object Model
Writing Sub Procedures
- Creating Sub Procedures
- Objects, Methods and Properties
- Collection Objects
- Using Varibles
- Using input boxes and message boxes
- Control structures
- Using IF…Then…Else statements
- Do…Loop
- For…Next
Variable Scope and Lifetime
- Creating Local Varibles
- Explicitly Declare Variables
- Shared Variables
- Global Variables
- Variable Data Types
- Variable Arrays
Procedure Scope
- Creating private procedures
- Calling procedures
- Shared procedures
Creating User Forms
- Building User
- Event programming
- Adding Controls to Forms
- Setting Form properties
- Running User Forms
Workingsheet and Workbook Events
- Creating Event driven programming
- Worksheet Events
- Workbook Events
- Macro Security