Duration
1 days
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.