Microsoft Excel VBA Macros Level 2 (2 days recommended)

Please specify the urgency and number of days

This in-depth two-day course provides Excel VBA developers with a more in-depth knowledge of Excel VBA objects: application, workbooks, worksheets, ranges, and user forms.

The course is suitable for those with good knowledge of Excel and familiarity with basics of VBA.

Course Outline

Excel object model

About classes and objects
Objects and collections
The hierarchy of objects
Properties, methods and events
The Locals Window
The Immediate Windo

Function procedures

Sub versus function
User-defined functions
Declaring a function
Calling a function
Private and public scope
Defining arguments
Optional arguments

The Application object

When to use
ScreenUpdating property
DisplayAlerts property
Setting CutCopyMode to false

Dialogue boxes

MsgBox function
InputBox function
Application.Dialogs

UserForms

Creating a userform
Displaying a userform
Adding Label controls
Adding a TextBox control
The CheckBox control
ComboBox and ListBox
Adding CommandButtons
Setting control properties

Workbooks and worksheets

The Workbooks collection
The Sheets collections
The Window objects
Workbook events

Ranges and names

Column and Row properties
CurrentRegion property
The Union method
The Intersect method
Using the Name property
Working with named range

Back to top