Duration
1 day
Overview
This one-day workshop introduces Microsoft Excel users to the advanced features in creating and managing Excel macro. In this Excel Macro course, participants will learn how to record macro, execute macros in variety of different methods, editing macro and creating a simple dialog boxes.
Objectives
- Open a Workbook Containing Macros
- Run a Macro
- Use a Shortcut Key
- Open the Visual Basic for Application Editor Window
- Record a Macro
- Assign a Shortcut Key
- Use Relative References
- Writing New Macro
- Assign a Custom Button to QAT
- Delete a Custom Button from QAT
- Delete a Macro
- Assign a Macro to a Button
- Create a Macro Button
- Use a Macro Button
- Create a Macro Button
- Copy a Macro Button
- Format a Macro Button
- Using Form Control
LESSON 1 - USING MACROS
DEFINING MACROS
OPENING A WORKBOOK CONTAINING MACROS USING DEVELOPER TAB
ENABLING MACRO VIA TRUST CENTER SETTING RUNNING A MACRO
USING A SHORTCUT KEY
OPENING THE VISUAL BASIC EDITOR WINDOW EXERCISE USING MACROS
LESSON 2 - RECORDING MACROS RECORDING A MACRO ASSIGNING A SHORTCUT KEY USING RELATIVE REFERENCES DELETING A MACRO
EXERCISE RECORDING MACROS LESSON 3 - EDITING MACROS WRITING A NEW MACRO ENTERING MACRO COMMENTS COPYING MACRO COMMANDS EDITING MACRO COMMANDS TYPING MACRO COMMANDS
RUNNING A MACRO FROM THE CODE WINDOW USING THE DEBUGGER
EXERCISE EDITING MACROS
LESSON 4 - CUSTOM BUTTON IN QUICK ACCESS TOOLBAR
CREATE A CUSTOM BUTTON
ASSIGN A MACRO BUTTON TO QUICK ACCESS TOOLBAR (QAT) CHANGE A BUTTON IMAGE
DELETE A CUSTOM BUTTON
EXERCISE CUSTOM BUTTON IN QUICK ACCESS TOOLBAR LESSON 5 – ADDING FORM CONTROLS TO A WORKSHEET USING FORMS CONTROLS
CREATE MACRO BUTTON FORMATTING A MACRO BUTTON RENAME A MACRO BUTTON
COPY AND RE-ASSIGN MACRO BUTTON MOVING/SIZING A MACRO BUTTON DELETING A MACRO BUTTON
CREATE COMBO BOX CONTROL USE SPINNER BUTTON
CREATE SCROLL BAR CONTROL CREATE OPTION BUTTONS CONTROL
EXERCISE ADDING FORM CONTROLS TO A WORKSHEET
Programme scope, delivery arrangements and suitability are confirmed during enquiry.