Designed for experienced Excel users who have already begun to create macros and know their way around Excel's Visual Basic Editor.
About classes and objects
Objects and collections
The hierarchy of objects
Properties, methods and events
The Locals Window
The Immediate Window
Sub
versus function
User-defined functions
Declaring a function
Calling a function
Private and public scope
Defining arguments
Optional arguments
When to use
ScreenUpdating property
DisplayAlerts property
Setting CutCopyMode to false
InputBox function
Application.Dialogs
Displaying a userform
Adding Label controls
Adding a TextBox control
The CheckBox control
ComboBox and ListBox
Adding CommandButtons
Setting control properties
The Workbooks collection
The Sheets collections
The Window objects
Workbook events
Column and Row properties
CurrentRegion property
The Union method
The Intersect method
Using the Name property
Working with named ranges
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