Microsoft Excel: Level 5 VBA Programming Introduction

Microsoft Excel: Level 5 VBA Programming Introduction

Pre-requisites: Students who wish to attend this course must have a very good working knowledge of Excel 2000, 2002(XP) or 2007.

Aims: This course is aimed at people who want to begin expanding their knowledge into enhancing, customising and automating the built-in functionality of Microsoft Excel.

Objectives:

On completion of this course delegates will be able to:
* Automate workbooks with recorded macros
* View and edit VBA code using the Visual Basic Editor
* Create shortcuts to run macros
* Create VBA code/macros from scratch
* Create decision making code
* Create Loops
* Understand and Use data variables
* Add interactivity to macros

Content:

Recording Macros
Working with Visual Basic Applications
Defining Macros
Recording & Running Macros
Using Relative & Absolute References
Saving Macros
Opening Workbooks Containing Macros
Using the Personal Macro Workbook
The Visual Basic Editor
Launching and Navigating the VBE
The Project Explorer Pane
Inserting, Renaming and Deleting
Module Sheets
Assigning Macros
Assigning a Shortcut Key
Adding & Assigning a Custom Button to a Toolbar
Assigning & Deleting a Macro from a Menu
Using a Macro Worksheet Button
Creating, Copying, Formatting & Deleting a Macro Button
Moving/Sizing a Macro Button
Writing Sub Procedures
Understanding Objects, Methods and Properties
Adding Arguments to Methods
Returning Properties
Writing Basic VBA Code and
Examples
The With... End With Block
The Offset Function
Dealing with a Run-time Error
The Object Browser
Control Structures
The IF THEN Control Structure
The IF THEN ELSE Control Structure
The SELECT CASE Control Structure
The DO Loop
Objects & Variables
Creating Variables
Assigning Values to Variables
Data Variable Types
Using Looping Control Structures
Using a For Next Statement
Using a For Each Next Statement
Interactive Macros
The Message Box Function
Creating a Custom Message Box
Creating a Custom Input
Appendix
Macro Security Levels
Changing Security Levels
Trusted Locations