VBA for Microsoft Excel (VBAE)

Course subjects

Understanding Templates and Macros

• Workbook projects

• Template projects

• Using the Personal.xls in Excel

• The project explorer

• The code window

• The toolbox

• The properties window

• Looking at the code created by the recorder

Controls - Command Buttons, Textboxes, and Labels

• Setting control properties

• Assigning code to respond to controls and click events

• Creating an event procedure

How Code is Stored

• Modules

• Forms

• Using comments

Writing Code That is Easy to Read and Navigate

• Sub procedures

• Function procedures

• Public procedures

• Private procedure

Data Types

• Declaring a variable or constant

• Using built in constants

Understanding Properties, Methods, Events, and Objects

• Using With…End With to set multiple property values for a single object

Understanding the Range Object (in Excel)

• Using cell addresses as range references

• Relative referencing

• Using the Offset property

Control Structures

• Decision structures

  • If... Then

  • If…Then…Else

  • If…Then... Elseif

• Select Case

• Looping Structures

  • Do…Loop

  • Do While…Loop

  • Do Until…Loop

  • Do…Loop While

  • Do…Loop Until

  • For…Next

  • For Each…Next

How to Handle Errors

• Designing an error handler

• Using Break Mode

• Using the Debugging window

• Avoiding bugs