VBA school training courses in Baltimore, MD (public, in-house or online)

Designed for experienced Access 2007 users who want to learn ActiveX Data Objects, control structures, and the basics of VBA programming. Prerequisite: Access 2007 Application Development or equivalent knowledge.

Gain proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code. Designed for experienced Excel users. Prerequisite: Excel 2007 Advanced or equivalent knowledge.

Learn how to build applications, debug code, automate data entry, and merge data files. Also learn how to create forms, build tables, secure information, and share data. Designed for experienced Word users. Prerequisite: Word 2007 Advanced or equivalent knowledge

You Will Learn How To

Develop customized solutions using Visual Basic for Applications (VBA)
Apply the object models to program effectively in the Microsoft Office System
Take full advantage of extensive built-in VBA functionality
Exploit ActiveX controls to create functional and familiar user interfaces
Troubleshoot code using VBA’s debugging tools
Secure your code and protect your users from macro viruses

Course Benefits

Effective business solutions do...

Full archival course description>>

This course will introduce students who are familiar with Word, Excel or Access the basics of writing and debugging VBA code. VBA is Microsoft’s Visual Basic for Application and is the tool used to create custom macros and user-interfaces in the Office applications. Students will learn to define variables, create loops and branching statements, define functions, get user input and interface with the application of their choice. Students will need a copy of Microsoft Word, Excel or Access. A...

Full archival course description>>