|
Introduction
to Microsoft Solutions Development
Introduction to Visual Basic for Applications Advantages of
Microsoft Excel as a Development Platform
Resources for Microsoft Excel Development
Exploring an Application Written in Visual Basic for Applications
Recording, Editing and Running Macros
Terminology
Using the Macro Reader
Working with Macros Assigning Macros Within the Environment
Editing Code
Creating Macros
Working with Visual Basic Code
Terminology
Variables
Sub Procedures
Function Procedures
Scope
Using the Visual Basic Toolbar
Tips for Browsing Lengthy Code Using Code From Help
Simple User Input, Control and Looping
User Input
Conditional Branching
Looping
Writing Looping and Conditional Code
Understanding
Objects, Properties and Collections
Objects
Properties Overview
Methods Overview
Object Variables
Collections
Common Collection Properties and Methods
Object Browser
Working With Objects
|
Working With Common Microsoft Excel Objects
The Range Object
Referencing Cells, Rows, Columns and Ranges
Working With Unknown Ranges Using Offset,
Resize and Current Region Formula, Value and FormulaArray.
Using ForEach With a Range of Cells
Working With Charts
Opening and Closing Workbooks
Working With Common Objects
Debugging and Error Handling
Identifying Types of Errors
Using the Debugging Tools in Visual Basic for Applications
Running Portions of Code
Monitoring Data and Error Handling
Debugging Visual Basic Code
Controls and Dialog Boxes
Introduction to Controls
Using Controls on Worksheets
Working With Custom Dialog Controls
Creating a Custom Dialog Box
Creating a Custom User
Interface
Terminology
Working With Toolbars Manually
Working With Toolbars Programmatically
Working With Menus Manually
Working With Menus Programmatically
Adding Help and Statusbar Messages
Adding Custom Menus and Toolbars to Microsoft Excel
|
