Add EXL3 to my courses Excel VBA Level 2 (2 days - £550, plus VAT)

Microsoft Excel VBA Training Courses in London

Designed for experienced Excel users who have already begun to create macros and know their way around Excel's Visual Basic Editor.

Excel object model

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

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 ranges

 

Back to top

Macresource Business SoftWare Training Courses
Access training | Excel training | Access VBA training | Excel VBA training
Project training | Visio training | Outlook training | Windows XP training
FileMaker training | MySQL training | PowerPoint training | Word training
Free computer software tutorials | London computer training room hire

© Copyright, Macresource 2011