Excel Macros and VBA Programming Introduction
Introduction
Microsoft Excel is the latest release of one of the world's leading Windows spreadsheet programs. Visual Basic for Applications is the programming language used when Macros are recorded and can turn a laborious manual process into a one-click function.
Objectives
To show how to record and run Macros. To teach the basics of VBA programming so that trainees can edit existing Macros and create their own procedures from scratch. By the end of the course participants will be able to further develop specific applications and models.
Designed for
Existing users of Excel Participants should have attended our "Microsoft Excel Advanced" course or attained a similar level of proficiency.
Duration
One day
Topics
- Introducing VBA concepts and terms
- How macros can automate your work
- Recording, editing and debugging macros
- Creating automatically executed macros
- Creating Macro buttons
- Creating Dialog boxes
- Customising a menu
- Making decisions within a Macro
- Repeating actions within a Macro
- Working with Modules
- Advanced macro commands
Follow-up
Individual consultancy and tuition as required