| 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 |
|
View Basket
Recover Basket
MS Excel 2007 VBA Level 2 (2 days)