Microsoft Excel Macros using VBA
Course Duration: 1 Day
 Printer-friendly
version
Course Objective
By the end of the course, delegates will be able to:
- Understand the
power of the Excel macro recorder
- Create and run basic macros
- View and edit macro code
- Add comments to macro sheets
- Use absolute and relative references in
macros and know when to use which
- Create custom toolbars
- Explore the object model, including collections,
objects, properties, and methods
- Create and edit toggle macros
- Run one macro from another using subroutines
and develop master macros
- Ask for data via input boxes
- Add on-sheet controls e.g. drop-down boxes
and command buttons
- Create basic dialog boxes
- Create multi-page forms
Delegate Profile
Existing users of Excel who wish to use the implementation
of Visual Basic for Applications to automate everyday tasks and to
add custom features and functions to their spreadsheet models.
Pre-Requisites
Delegates should have a sound working knowledge of application
as per our Excel Expert course, and should be familiar
with a wide range of Excel functions.
Structure
Each delegate has the exclusive use of a PC and training includes extensive
hands-on activity.
Course Content
What are Macros?
Excel macros Visual Basic for Applications
- overview
Recording actions and running a macro
Recording macros
Absolute and relative references
Using the menu
Creating custom toolbar buttons
Adding command buttons
Custom tool menu command
Viewing the code
Colour coding
Adding comments
Amending the code generated by the macro recorder
Explore the object model
Explore the collections,
objects, properties and methods
Use the object browser
Set properties and apply methods
Creating toggle macros
Macros to reverse the current status of an object
Calling subroutines
Running one macro from another
Developing a master macro
Using interaction
Displaying messages
Asking for data via input boxes Customising Excel
Adding on-sheet controls e.g. drop-down lists, command
buttons and check-boxes
Create multi-page forms for ease of entering list – type data
Creating basic dialog boxes
Where next?
The 3-day Excel VBA Development course features & benefits.
 Back
to the top
|
