Description

This in-depth one-day instructor-led course provides students with the knowledge and skills to use advanced features of Microsoft Excel macros. Participants will learn how to record macros, execute macros in variety of different methods, edit macros and create simple custom controls.

Target Audience

Prerequisites

• At least one year intermediate experience using Excel 2000 or 2002

Objectives

• Open a workbook containing macros
• Run a macro
• Use a shortcut key
• Use the Microsoft Visual Basic toolbar
• Open the Visual Basic Editor window
• Use the Visual Basic Editor window
• Record a macro
• Assign a shortcut key
• Use relative references
• Assign a macro to a menu
• Delete a macro from a menu
• Delete a macro
• Use custom toolbars and buttons
• Create a custom toolbar
• Add a button to a toolbar
• Add a custom button
• Assign a macro to a button
• Change a button image
• Display button text and images
• Attach a custom toolbar
• Delete a custom toolbar
• Create a macro button
• Use a macro button
• Create a macro button
• Copy a macro button
• Format a macro button
• Move and size a macro button
• Delete a macro button

Outline

• Module 1: Using Macros
  • Automate Tasks with Macros
  • Set Macro Security
  • Run a Macro
  • Run a Macro Using a Shortcut Key
  • Use the Visual Basic Toolbar
  • Lab : Review and Practice

• Module 2: Recording Macros
  • Record a Macro
  • Assign a Shortcut Key
  • Record a Macro that Uses Relative Referencing
  • Delete a Macro
  • Delete a Macro Stored in a Personal Macro Workbook
  • Lab : Review and Practice

• Module 3: Editing Macros
  • Open the Visual Basic Window
  • Use Visual Basic Editor
  • Edit Macro Commands
  • Copy Macro Commands
  • Write a New Macro
  • Run a Macro from the Code Window
  • Lab : Review and Practice

• Module 4: Using Custom Toolbars and Menus
  • Create a Custom Toolbar
  • Add Toolbar Buttons
  • Assign a Macro to a Custom Button
  • Change a Button Image
  • Display Button Text and Image
  • Attach a Custom Toolbar to a Workbook
  • Delete a Custom Toolbar
  • Create a Custom Menu
  • Add Custom Menu Commands
  • Lab : Review and Practice

• Module 5: Adding Custom Controls to a Worksheet
  • Add Custom Controls to a Worksheet
  • Work with Macro Buttons
  • Create a Combo Box Control
  • Use a Spinner Control
  • Create a Scroll Bar Control
  • Create an Option Buttons Control
  • Lab : Review and Practice