fourth r computer training sydney melbourne central coast newcastle
Excel 2010: Macro
Course Code: AD609

Outline
Recording Simple Macros
Recording and running a Personal Macro
Displaying Macro Instructions
Editing a Macro
Using Absolute and Relative references

Creating and using Workbook Macros
Recording and running a Workbook Macro
Adding a Macro button to a worksheet

Using Visual Basic to write Macros
Opening a new Module in the VB editor
Displaying a Data Prompt
Using a Conditional statement
Using a Control loop in a Macro
Additional Control statements
Placing Controls on a Worksheet
Placing a Combo box list and Check box on a Worksheeet/Linking a Control to data

Creating a Macro toolbar
Adding a Macro button to the Quick Access toolbar
Assigning a Macro to a toolbar

Creating a Macro menu
Creating a new menu
Adding an image to a Macro toolbar button

Using the Visual Basic Help system
Displaying Visual Basic help information
After completing this course, students will know how to:
  • Record, Edit and Run a Personal and Workbook Macro.
  • Use an Absolute and Relative reference in Macros.
  • Add a Macro button to the Quick Access toolbar.
  • Display Data Prompts
  • Use a Conditional statement and a Control loop in a macro
  • Place a Drop-Down list box and a Check box on a worksheet.
  • Use Visual Basic to write a macro.
Contact The Fourth R
computer training computer training join
computer training discounts
 
 
Copyright © The Fourth R. All Rights Reserved.