Module 1: 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.

Module 2: 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.

Module 3: 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.

Module 4: Custom Button in Quick Access Toolbar

This module demonstrate how to create custom buttons in the Quick Access Toolbar.

Lessons

• Creating a Custom Button
• Adding a Button to Quick Access Toolbar
• Assigning a Macro to a Button
• Changing a Button Image
• Deleting a Custom Button

Lab: Custom Button in Quick Access Toolbar

After completing this module, students will be able to:

• Use custom button in Quick Access Toolbar.
• Assign Macro to custom button.
• Delete custom button.

Module 5: Adding Forms Controls to a Worksheet

This module explains how to create forms control onto a worksheet.

Lessons

• Creating a Macro Button
• Copying a Macro Button
• Formatting a Macro Button
• Moving/Sizing a Macro Button
• Deleting a Macro Button

Lab: Adding Forms Controls to a Worksheet

After completing this module, students will be able to:

• Create forms control for a Macro.
• Format Macro button.
• Delete Macro button.