Automating Excel using
Visual Basic for Applications
This three-day course is designed for people who are looking to use Visual Basic for Applications to automate Microsoft Excel making it easier for you or your end-users to operate. It covers the minimum skills required to get the best out of programming Excel. Each delegate will carry out various practical exercises during the course, which involves them working through examples of each subject covered.
Course Outline
- See the Visual Basic for Applications editor
- Understand about recording macros
- Cover working with objects
- Meet the Excel object model
- See how to program worksheets and workbooks
- Cover VBA language concepts
- See how to declare different data types
- Understand commands and statements
- Learn how to use variables and constants
- Cover programming event procedures
- Control program flow with conditional constructs and looping
- Learn how to create your own procedures and functions
- See how scope and lifetime of variables affect programming projects
- Find out how to interact with users
- Learn to create your own forms and dialogues
- Cover using error handling and debugging code
Who would benefit from the course?
This course is designed for Excel users who wish to give more functionality to users and improve automation of tasks within Excel.
Pre-requisites
A good understanding of Excel as a user.
