Microsoft Excel: Visual Basic for Applications (VBA): Level 5 - Introduction to VBA

Course Overview

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.

Delegates that attend a Microsoft training course are twice as productive/efficient/motivated than those that don't?

Related Courses

• Microsoft Excel 2007: Upgrade New Features
• Microsoft Excel 2007: Introduction for Beginners (1 day)
• Microsoft Excel 2007: Visual Basic for Applications (VBA) Programming (2 day)
• Microsoft Excel 2007: Advanced (1 day)
• Microsoft Excel 2007: Intermediate (1 day)
• Microsoft Excel 2007: Intermediate (2 day)
• Microsoft Excel 2007: Advanced
• Microsoft Excel 2007: Formulae & Functions
• Microsoft Excel 2007: Charts, Pivot Tables & Macros
• Microsoft Excel 2007: Intermediate and Advanced Training Course

Audience

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

Skills Gained

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

Course Outline

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

Microsoft Excel: Visual Basic for Applications (VBA): Level 5 - Introduction to VBA / XLL5

Request availability or enquire by clicking a date: