 | |
Microsoft™
Excel
MACRO PROGRAMMING
Prerequisites:
Excel 2 or Equivalent What Is A
Macro
 |
Concept and Language |
What Macros
Can Do For The User
|
Examples and
Demonstration of Several Macros |
Types Of
Macros
|
Procedure Macros |
|
Function Macros |
Ways To
Execute Macros
|
From the Macro
Command on the Tools Menu |
|
Adding Macros to the
Tools Menu |
|
Assigning Macros to
Toolbar Icons |
|
Worksheet Command
Buttons |
|
Shortcut Keys |
How Excel
Handles and Stores Macros Creating
Basic Macros
|
Fundamentals of
Creating Macros |
|
Creating a Simple
Macro with the Macro Recorder |
|
Testing the Macro |
Viewing The
Visual Basic Code
|
From the Toolbar |
|
From the Active
Workbook Module |
Visual Basic
|
Reading and
Understanding Visual Basic |
|
Objects, Properties,
Methods, and Variables |
Documenting
and Editing The Visual Basic Macro
|
Adding Descriptive
Information and Comments |
|
Changing the Code of
a Recorded Macro |
|
Re-Testing the
Edited Macro |
Creating
Macros To Perform Standard Routines
|
Open a Standard
Preformatted Worksheet |
|
Chart Periodically
Updated Data from a Worksheet |
Further
Automating The Running Of Macros
|
Creating Macro
Command Buttons |
|
Assigning Macro
Icons to A Customized Toolbar |
Creating
Simple Macros With Visual Basic Editor
|
Exiting to MS/DOS |
|
Formatting Cells
for Font, Color, Patterns, and Borders |
|
Setting Column Width |
|
Data Entry Macros
for Public Worksheets |
Inserting
New Code Using The Macro Recorder Importing
And Charting Data With Macros
|
From DOS Files |
|
From Other Windows
Applications |
|
From Mainframe
Applications |
Executing
Macros Within Macros
|
Dividing Large
Macros |
|
Use of a Macro by
Another Macro |
|
Building Subroutines |
 
You can print this page with your web browser |
