In this hands-on Introduction to VBA Programming training course, you gain a detailed understanding of how programming in Visual Basic for Applications (VBA) can increase productivity. With this VBA training, you learn how to automate repetitive tasks, build fully functional user interfaces, leverage tools for developing custom-built Microsoft Office solutions, and supercharge your productivity and the productivity of others.
TRAINING AT YOUR SITE
Our FlexVouchers help you lock in your training budgets without having to commit to a traditional 1 voucher = 1 course classroom-only attendance. FlexVouchers expand your purchasing power to modern blended solutions and services that are completely customizable. For details, please call 888-843-8733 or chat live.
*Events with the Partial Day Event clock icon run longer than normal but provide the convenience of half-day sessions.
Jul 21 - 24 9:00 AM - 4:30 PM EDT Online (AnyWare) Reserve Your Seat
Sep 29 - Oct 2 9:00 AM - 4:30 PM EDT Online (AnyWare) Reserve Your Seat
Nov 3 - 6 9:00 AM - 4:30 PM EST New York / Online (AnyWare) Reserve Your Seat
Mar 9 - 12 9:00 AM - 4:30 PM EST Herndon, VA / Online (AnyWare) Reserve Your Seat
Guaranteed to RunWhen you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time — will run. Guaranteed.
Partial Day EventLearning Tree offers a flexible schedule program. If you cannot attend full day sessions, this option consists of four-hour sessions per day instead of the full-day session.
The advantages of VBA
Macros: the first step
The code design tools
The debugging tools
Putting objects to work
Storing data in variables
Looping through code
Understanding object model structures
Writing application-specific procedures
Exploiting the power of Automation
Using intrinsic dialogs
Creating customized dialogs with UserForm objects
Modifying menus and toolbars
Handling runtime errors
Yes! We know your busy work schedule may prevent you from getting to one of our classrooms which is why we offer convenient online training to meet your needs wherever you want. This course is available in class and live online.
This course is applicable to all versions of Office, from 2007 to 2016.
Excel Data Analysis TrainingIntroduction to Business Analysis Training: Defining Successful ProjectsIntroduction to Project Management TrainingProgramming with Visual Basic .NET TrainingIntroduction to Microsoft Access TrainingPower Pivot for Excel: Mining Data for Business Intelligence