Duration
1 day
LESSON 1: USING MACROS
Defining Macros
Using Developer Tab
Running A Macro
Enabling Macro Via Trust Center Setting
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
LESSON 3: EDITING MACROS
Writing A New Macro
Entering Macro Comments
Copying Macro Command
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 Control
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.