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
Overview of debugging
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.
