Using Macros

This module gives the introduction of how to execute Macros.

Lessons

• Opening a Workbook Containing Macros
• Running a Macro
• Using a Shortcut Key
• Using the Visual Basic Toolbar
• Opening the Visual Basic Application Window
• Using the Visual Basic Application Window

Lab : Using Macros

After completing this module, students will be able to:

• Understand how to execute Macros.

Recording Macros

This module explains how to create Macros through usage of recording.

Lessons

• Using the Developer Tab
• Recording a Macro
• Assigning a Shortcut Key
• Using Relative References
• Deleting a Macro

Lab : Recording Macros

After completing this module, students will be able to:

• Record Macros
• Assign Shortcut Key to Macro
• Using Relative Reference in Macro Recording

Editing Macros

This module explains how to start editing simple commands within the Visual Basic Editor.

Lessons

• Writing a New Macro
• Entering Macro Comments
• Copying Macro Commands
• Editing Macro Commands
• Typing Macro Commands
• Create Message box
• Running Macro from the Code Window
• Using the Debugger

Lab : Editing Macros

After completing this module, students will be able to:

• Write simple Macro commands
• Create message box
• Insert comments