|
|
|
Excel 2000 Programming with VBA
Version 9.0
Prerequisites
Proficient knowledge of Excel 2000 or Excel 97. Advanced knowledge of PivotTables helpful but not required.
|
| Duration 2 day(s) |
Gettting Started
- Introducing Visual Basic for Applications
- Recording a Macro
- Running a Macro
- Understanding the VB Editor
Using the Menu Bar
- Using the Standard Toolbar
- Using the Project Explorer
- Using the Properties Window
- Understanding the Code Window
Understanding Code Window Options
- Editing Code
- Getting Help
- Closing the Visual Basic Editor
Introducing Objects
- Understanding the Object Browser
- Understanding Objects
- Understanding the Object Hierarchy
- Referencing Objects
- Understanding Collections
Using the Editing Features
- Using the Immediate Window
- Using the Auto List
- Using Auto Quick Info
Introducing Variables
- Understanding Variables
- Declaring Variables
- Understanding Data Types
- Storing Values in Variables
- Storing Objects in Variables
Creating Procedures and Functions
- Understanding Procedures
- Using the Macro Recorder to Create Sub Procedures
- Calling Procedures from Procedures
- Using Intrinsic Functions
Using Message Boxes
- Using Input Boxes
- Creating Functions
- Passing Arguments to a Function
- Working with Conditional Statements
- Understanding Conditional Statements
- Working with Decision Structures
- Working with Looping Structures
Working with Forms and Controls
- Understanding UserForms
- Using the Toolbox
- Working with UserForm Properties, Events, and Methods
- Using the Properties Window
Understanding Controls
- Working with the Label Control
- Working with the Text Box Control
- Working with the Command Button Control
- Working with the Combo Box Control
Working with the Frame Control
- Working with Option Button Controls
Adding Functionality to Forms
- Working with Control Appearance
- Setting the Tab Order
- Populating a Control
- Adding Code to Controls
- Launching Forms from Procedures
Using PivotTables
- Understanding PivotTables
- Creating PivotTables
- PivotTable Arguments
- Adding Fields to PivotTables
Controlling Forms
- Controlling PivotTables from a Form
- Controlling a Form from a Custom Toolbar
Understanding Debugging
- Understanding Errors
- Debugging Code
- Debugging Tools
- Using the Locals Window
Using the Watch Window
WEXP90 ONLINE - 8/16/1999 0:00:00
|
