UMSL logo

Computer Education & Training Center

Excel VBA

Excel VBA (Visual Basic for Applications) Classes

Take your skills to the next level with comprehensive Excel VBA training. Understand how to write a macro and learn to create and edit VBA code to automate tasks and become more productive by attending a class at the Computer Education & Training Center at UMSL.

The class below is offered in the Excel 2010 version. Students with either Excel 2007, Excel 2013, or Office 365 could also take this class since the versions (Excel 2007, 2010, 2013 and Office 365) are very similar.

Excel Macros Using VBA

(Prerequisites: Significant Excel experience and Intermediate Applications of Excel or equivalent experience. Students should have a solid knowledge of Excel, a strong background using conditional statements, and substantial experience working with spreadsheets before taking this class.) In this two-day class, discover the power of macros by using Visual Basic for Applications to automate your Excel applications. Visual Basic terminology, such as procedures, methods, properties, and objects, will be introduced and used to create and edit Excel macros. Understand how to modify recorded macros and write original macros using Visual Basic in order to customize your interface and create dialog boxes for input and messages. Additional topics include using control structures, such as conditionals and loops.
Fee: $399

Excel 2010  [Course Outline]
Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
G6310 Wed., Sept. 9 & Thurs., Sept. 10West CountyBill Barry
G6590 Tues., Nov. 3 & Wed., Nov. 4West CountyBill Barry

Intermediate Excel VBA

(Prerequisite: Excel Macros Using VBA or equivalent experience.) Explore Excel VBA in more depth with this second level class. Understand Objects and how to navigate the Excel Object hierarchy. Create an event procedure and work with methods, forms, and controls. Topics include adding code to controls, using the toolbox, and working with procedures and functions. Additional topics include using global variables and arrays, expressions, controlling program execution, error trapping, and code debugging.
Fee: $399

Excel 2010 
Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
G6591 Mon., Nov. 16 & Tues., Nov. 17West CountyBill Barry

If you would like to register for a course, call (314) 984-9000 or register online.

Beginning through advanced level Excel classes are available as well as classes in Excel Charts, PivotTables, Formulas and Functions, and Excel Data Manipulation.