Microsoft 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

Download Course Outline