Programming Microsoft Excel with VBA 2003/2007
Do you need to:
- Bulid and edit macros using VBA
- Create customized menus and dialog boxes
Prerequisites:
- A sound knowledge of designing and creating workbooks and using Excel functions
By the end of the course you will be able to:
- Use tha macro recorder to record Excel operations and create working applications
- Create user defined functions
- Work with the Visual basic Editor
- Work with Excel Objects
- Create custom forms
- Use conventional programming
- Cusomise the menu systems to run VBA procedures
- Work with automatic startup and shutdown procedures
Trainer:
Peter Harvest
Queries should be directed to training@melbpc.org.au.