Introduction
What is a Macro?
Recording a Macro
Running a Macro
Relative References
Section 2
Assigning a Macro to a Button on a Sheet
Assigning a Macro to a Drawn Object on a Sheet
Assigning a Macro to a Button on a Toolbar
Customising a Toolbar
Creating a Toolbar
Button Image Editor
Changing a Button’s ScreenTip
Section 3
Visual Basic Editor
Project Explorer
Procedures
Sub Procedures
Inserting Comments
Printing a Visual Basic Module
:: Course Microsoft Excel 2003 Visual Basic for Applications ::
Introduction
Cells Method
Range Method
Selecting Range Objects
Flexible Ranges
Offset Method
Resize Method
Selection, ActiveCell and Activate Methods
Row and Column Properties
Rows and Columns Methods
End Method
Combining Methods
Virtual Worksheets
Range Contents
Value Property
Formula Property
FormulaR1C1 Property
Techniques for Inserting Values in the Next Blank Row
NumberFormat Property
Section 5
Activating a Workbook
Activating a Worksheet
ThisWorkBook
Section 6
Controlling Objects with their Properties
Setting a Property Value
Returning a Property Value
Performing Actions with Methods
Using Methods
Using Named arguments
Performing Multiple actions on an Object
:: Course Microsoft Excel 2003 Visual Basic for Applications ::
Section 7
Variables
Declaring Variables
Local, Module-Level and Public Variables
Naming Variables
Data Types
Variant Data
Specific Data Types
Numeric Data
Character Data
Date and Time
Boolean
Arrays
Objects
Constants
Section 8
Conditional Control Structures
IF...THEN...ELSE
SELECT CASE
Looping Control Structures
Do...Loop
Repeating Statements While a Condition is True
Repeating Statements Until a Condition becomes True
Exiting a Do...Loop Statement from inside the Loop
FOR...NEXT
FOR EACH...NEXT
Non-Structured Statements
GoTo
Sub Procedures
Calling Procedures in Another Workbook
Passing Arguments to Subprocedures
:: Course Microsoft Excel 2003 Visual Basic for Applications ::
Introduction
Built-In Dialog Boxes
Predefined Dialog Boxes
InputBox Function
MsgBox Function
Number and type of button:
Icon style:
Default button:
Section 11
GetPrivateProfileString
About Toolbars and Menus
Attaching Toolbars to Workbooks
Save More Than One Toolbar Configuration
Customised Toolbars
Customising a Toolbar
Display
ScreenUpdating
DisplayAlerts
Section 12
Errors
Types of Errors
Break Mode
Setting Breakpoints
Instant Watch
Stepping
Error Handling
On Error Goto Label
Resume and Resume Next
On Error Goto 0
Err Function
Error() Function
Error and Err Statements
Error Handling Example
:: Course Microsoft Excel 2003 Visual Basic for Applications ::
Section 13
Worksheet Object Events
Workbook Object Events
Introduction
User-Defined Functions
Function Wizard
Excel Functions
Programme scope, delivery arrangements and suitability are confirmed during enquiry.