Lesson objectives help students become
comfortable with the course, and also provide a means to evaluate
learning. Upon successful completion of this course, students
will be able to:
- Run macros and explain the basics of a
Visual Basic Module.
- Create relative and absolute recorded
macros and assign macros to various objects in a
workbook.
- Write procedures that test conditions and
then run only certain statements based on the results.
- Write procedures that execute one or more
lines of code repetitively.
- Store Excel macros so they are available
in any workbook.
- Create macros in Word 2000.
- Create macros that interact with the user.
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
You will need 32 megabytes (MB) of Random
Access Memory (RAM), an x86-compatible PC that meets the minimum
hardware requirements for Windows 95 or later or Windows NT 4.0
or later, 500 MB of free hard-disk space, a typical installation
of Windows 98, and a custom installation of Office 2000.
In addition, you will need printers if you want
to print the worksheets or documents created in the course.
