Excel VBA Outline
During this VBA session you will be shown how to automate and customise Excel using macros and controls, such as buttons and menus. Delegates learn how to write macros using VB code and assign macros to screen items
Course details
Using the Macro Recorder
- Recording a Macro
- Using Absolute references
- Personal Macro Workbook
- Assigning shortcut keys
- Deleting Macros
- Using Relative references
Creating and Editing Macros using VBA
- Macro storage concepts
- The VBA Editor
- Program Components
- Introduction to Editing code
- Copying and Pasting procedure
- Linking Procedures
- Create and user a user-defined function
- Auto-executable macros
Objects and Dialog Boxes
- Introduction to Objects
- The Object browser
- User defined dialog boxes – message and input boxes
Introduction to Controls
- Worksheet Controls
- Creating User forms
Level
AdvancedDuration
1 day (but can be run as shorter sessions)Course Requirements
Delegates should have a good grounding in Excel and be familiar with absolute vs relative cell referencing, functions and formula syntax, pivot-tables and sheet linking. Familiarity with the macro recorder would be an advantage.
Contact
Email the Training Team for more information and availability at training@prosperity247.com
