|
Microsoft
Office 2000: Macro Programming Using Visual Basic for
Applications
Prerequisites: Windows, Excel 2000: Worksheets, Excel 2000: Advanced,3 Word
2000: Level 1, Word 2000: Level 2, and Word 2000: Advanced or
equivalent knowledge.
Lesson 1: Introduction to
Visual Basic for Applications
- Running a macro
- Recording a macro
- Examining module design
Lesson 2: Assigning
macros
- Specifying the location of
recorded macros
- Assigning macros to menus,
buttons, and toolbars
Lesson 3: Creating
decision-making code
- The If…Then decision structure
- The If…Then…Else decision
structure
- The Select Case decision
structure
Lesson 4: Using loop
structures
- Using a For…Next statement
- Using a Do…Loop statement
- Using a For Each…Next
statement
Lesson 5: Macro
management
- Personal Macro Workbook
- Assigning Sub procedures to run
automatically
Lesson 6: Recording a
macro in Word 2000
- Running a macro
- Recording a macro
Lesson 7: Interactive
macros
- Creating a custom message box
- Creating a custom input box
- Extracting data from Excel
Appendix A: Using macros
in PowerPoint and Access
- Using macros in PowerPoint
- Using macros in Access
Appendix B: Debugging and
testing code
|
