Amazing Macros - Microsoft® Office Excel® 2007 & 2010
Course Content
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
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
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
Module 4: Custom Button in Quick Access Toolbar
This module demonstrates 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
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