Course description
Programming Microsoft Excel with VBA
This course will enable you to use Excel Visual Basic for Applications (VBA) to automate and customise spreadsheets. Were appropriate your own work requirements may be used as course examples.
Do you work at this organisation and want to update this page?
Is there out-of-date information about your organisation or courses published here? Fill out this form to get in touch with us.
Upcoming start dates
Choose between 2 start dates
Suitability - Who should attend?
It is assumed that you will be familiar with a wide range of Excel features, in addition to being a competent Microsoft Windows user.
Outcome / Qualification etc.
At the end of this course you will be able to:
- Appreciate the benefits of using Visual Basic (VBA) macros.
- Record, run and edit basic Excel macros.
- Interpret and edit VBA code.
- Apply programming techniques such as conditional branching and loops to your macros.
- Acquisit user data and display messages.
- Create User Forms to manage complex user input.
Training Course Content
- Introducing Macros
- VBA (Macro) Basics
- Cell Referencing
- Editing VBA Program Code
- Extending Control
- User Forms
- Troubleshooting Problems
Request info
Ads