VBA Programming Introduction

The advantages of VBA

• An easy-to-use and versatile language
• Integrated with off-the-shelf products

Macros: the first step

• Recording and executing macros
• Limitations
• Enhancing with VBA code

The code design tools

• Project Explorer
• Help system
• Code Window
• IntelliSense
• Properties Window
• Object Browser

The debugging tools

• Code stepping
• Immediate Window
• Breakpoints

Event-driven programming

• The role of events in Windows
• Responding to events through event procedures

Putting objects to work

• Properties
• Methods
• Events
• Collections
• Using With...End With

Storing data in variables

• How and when to declare variables
• Selecting data types
• Fixed and dynamic arrays
• Constants

Conditional branching

• If ... Then ... Else
• Select ... Case

Looping through code

• Do ... Loop, While and Until
• For ... Next and For Each ... Next

Building procedures

• Creating Sub and Function procedures
• Calling procedures
• Passing arguments to procedures

Understanding object model structures

• Exploring the hierarchy with the Object Browser and Help
• Referencing specific objects

Writing application-specific procedures

• Key objects within Excel, Word and Outlook
• Creating templates and add-ins

Exploiting the power of Automation

• Controlling one Office application while working in another application
• Accessing data in databases using ActiveX Data Objects

Using intrinsic dialogs

• Communicating with the user through the message box
• Gathering user information with the input box
• Utilising the FileDialog object and Dialogs collections

Creating customised dialogs with UserForm objects

• Command buttons
• List and Combo boxes
• Labels
• Option buttons
• Check boxes
• Text boxes
• Frames
• Adding more functionality with advanced ActiveX controls

Modifying menus and toolbars

• Simplifying user interaction with the CommandBar object
• Adding and removing CommandBarControl objects

Handling runtime errors

• The On Error GoTo structure
• Classifying errors with the Err object
• Executing with Resume, Resume Next or Resume label

Implementing security

• The dangers of macro viruses
• Macro security levels in Office
• Applying digital signatures to macros
• Password-protecting your VBA code