Mac Excel VBA Macros
Training
Inhouse
Description
-
Type
Training
-
Methodology
Inhouse
To develop automated procedures in Excel using the Visual Basic for Applications language.
Reviews
Course programme
Course Contents
What is a Macro?
Concept and discussion
The Visual Basic Interface
- The Project Window
- Code Window
- Properties Window
- Navigating between Excel and the VB Editor
Recorded Macros
- Record New Macro
- Assigning a keyboard short cut
- Saving with the file
Methods of Executing
- Menu
- Visual Basic Toolbar
- Keyboard Shortcut
- Custom Toolbar Button
- Custom Menu Item
- Button
- Alt [F8]
- Forms Toolbar
Editing the Code
- Using the Visual Basic Editor
- Structure of a sub routine
- Describe the colour scheme of Key Words
- Navigation in a Module
- Editing in a module
- Use of Function Keys
- Reassign keyboard shortcut
- Run subroutines together
Checking For Errors
- Debugging
- Step Mode
- Immediate Window
- Object Browser
- Toggle Breakpoint
- Help system
Types of Recording
- Relative
- Absolute
Portability
- Personal Macro Workbook
- This Work Book
- New Workbook
- Add-ins
Creating New Functions
- Uses
- Function Keyword
- Use of Arguments
- Variables
- Constants
Additional information
Mac Excel VBA Macros