PDF Add to WishList
In this advanced course, you gain a detailed understanding of how programming in Visual Basic for Applications can increase productivity. With this 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.
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
Course Tuition Includes:
After-Course Instructor Coaching
When you return to work, you are entitled to schedule a free coaching session with your instructor for help and guidance as you apply your new skills.
After-Course Computing Sandbox
You'll be given remote access to a preconfigured virtual machine for you to redo your hands-on exercises, develop/test new code, and experiment with the same software used in your course.
Free Course Exam
You can take your course exam on the last day of your course and receive a Certificate of Achievement with the designation "Awarded with Distinction."
Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm
FREE Online Course Exam (if applicable) – Last Day: 3:30 pm – 4:30 pm
By successfully completing your FREE online course exam, you will:
“I really appreciated the way we online students were able to participate in the VBA programming class via AnyWare. It did not feel at all like we were thousands of miles away!”
- Y. Freeman, Director of Marketing Operations
Macy’s Inc. Software