Microsoft Excel - Macros
Excel Macros (Versions 2003 to 2007)
Duration: Two Days
| Aims and Objectives of the workshop | This course covers automation and customising of Excel using macros and screen items (such as buttons and menus). Delegates learn how to record macros using VB code and assign macros to screen items. At the end of the workshop delegates will feel confident in using VBA for excel |
| Who should attend | Excel users who, at intermediate or advanced level, want to learn how to speed up and automate their work (or other users' work) in the application using macros. |
| Experience needed | Delegates should have a good grounding in Excel (any version) and be familiar with absolute Vs relative cell referencing, functions and formula syntax and sheet linking. Familiarity with the macro recorder would be an advantage. However, those wishing to learn or practice VBA itself should seek another course. |
Course Content
Introduction
- What is a Macro?
- Good Practice
- Good Planning
- Good Habits
- Demonstration
- Run a Pre-recorded Macro
The Excel Macro Recorder
- Introduction to the Macro Recorder
- Recording a Macro.
- Running a Macro
- Relative and Absolute Recording
Macro Storage
- Introduction
- The Default Macro Storage Location
- The Personal Macro Workbook
- Macro Shortcut Keys
- Assigning a Shortcut Key
- Deleting Macros
Macro Storage Concepts (within the visual basic program)
- Modules
- The VB Editor
- Working With Modules
- Projects
- Editing Macros
- Introduction
- Editing a Macro
- Aspects of Macro Procedures
- Copying Macros
- Copying Code
- Linking Macros
- Linking or Calling Macros
User-Defined Functions (create your own calculation functions)
- Introduction
- Creating a User-Defined Function
- Using a User-Defined Function
- Globally Available User-Defined Functions
- Auto Executable Macros
- The Automatic Features
Objects (boxes seen on screen when a macro is run)
- Introduction
- The VBA Object Browser
- Built-In Dialog Boxes
- Custom Dialog Boxes
- Message Boxes
- The MsgBox function
- Input Boxes
- Declaring Message Boxes and Input Boxes as Variables
- Assigning a Macro to a Toolbar Button
Please note that sections of this course can be mixed with other courses to create your own bespoke training package.