| Objectives | This course explores the basics of VBA programming and the use of event driven programming. After completing this course, participants will be able to: understand VBA constructs and Microsoft Office VBA Objects, understand class modules, work with VBA procedures, build toolbars and menus. The course also covers the use of controls on Office documents and creating custom UserForms to automate an
application. |
| General thematics |
- Visual Basic for Applications (VBA) programming language, Visual Basic Editor (VBE);
- Microsoft Word, Microsoft Excel, Microsoft PowerPoint object models;
- Controls, UserFoms;
- Class modules;
- Error handling;
- ADO technology for data sources access.
|
| Seminary / Laboratory thematics | Extensive hand-on exercises provide participants with practical experience automating Office tasks with VBA programming. Exercises include:
- building user interfaces with standard and custom controls,
- automating a document,
- programming an add-in,
- error-handling,
- retrieving database data.
|
| Teaching methods | PowerPoint presentations with examples |
A. I. Cuza University of Iaşi