VBA Programming Introduction
COURSE TYPE
Practitioner
Course Number
209
Duration
4 Days
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.
You Will Learn How To
- Develop custom solutions, automate tasks, and increase performance
- Enhance the Office 2007-2016 Ribbon with new functionality
- Exploit ActiveX controls to create functional and familiar UIs
- Troubleshoot code using debugging tools
- Secure your code and protect your users from macro viruses
Important Course Information
Recommended Experience:
- Familiarity with Microsoft Office applications
Software:
- This course is applicable to all versions of Office, from 2007 to 2016
Course Outline
- Introduction
The advantages of VBA
- An easy-to-use and versatile language
- Integrated with off-the-shelf products
Macros: the first step
- Recording and executing macros
- Limitations
- Enhancing with VBA code
- Getting to Know the VBA Environment
The code design tools
- Project Explorer
- Help system
- Code Window
- IntelliSense
- Properties Window
- Object Browser
The debugging tools
- Code stepping
- Immediate Window
- Breakpoints
- Writing VBA Code
Event-driven programming
- The role of events in Windows
- Responding to events through event procedures
Putting objects to work
- Properties
- Methods
- Events
- Collections
- Using With...End With
Storing data in variables
- How and when to declare variables
- Selecting data types
- Fixed and dynamic arrays
- Constants
Conditional branching
- If...Then...Else
- Select...Case
Looping through code
- Do...Loop, While and Until
- For...Next and For Each...Next
Building procedures
- Creating Sub and Function procedures
- Calling procedures
- Passing arguments to procedures
- Empowering VBA through the Application Object Models
Understanding object model structures
- Exploring the hierarchy with the Object Browser and Help
- Referencing specific objects
Writing application-specific procedures
- Key objects within Excel, Word and Outlook
- Creating templates and add-ins
Exploiting the power of Automation
- Controlling one Office application while working in another application
- Accessing data in databases using ActiveX Data Objects
- Building Intuitive User Interfaces
Using intrinsic dialogs
- Communicating with the user through the message box
- Gathering user information with the input box
- Utilizing the FileDialog object and Dialogs collections
Creating customized dialogs with UserForm objects
- Command buttons
- List and Combo boxes
- Labels
- Option buttons
- Check boxes
- Text boxes
- Frames
- Adding more functionality with advanced ActiveX controls
Modifying menus and toolbars
- Simplifying user interaction with the CommandBar object
- Adding and removing CommandBarControl objects
- Providing a Safe and Secure Environment
Handling runtime errors
- The On Error GoTo structure
- Classifying errors with the Err object
- Executing with Resume, Resume Next or Resume label
Implementing security
- The dangers of macro viruses
- Macro security levels in Office
- Applying digital signatures to macros
- Password-protecting your VBA code
Convenient Ways to Attend This Instructor-Led Course
Hassle-Free Enrollment: No advance payment required to reserve your seat.
Tuition due 30 days after you attend your course.
In the Classroom
Live, Online
Private Team Training
In the Classroom — OR — Live, Online
Tuition — Standard: $2990 Government: $2659
Aug 15 - 18
(4 Days)
9:00 AM - 4:30 PM EDT
Alexandria, VA / Online (AnyWare)
Reserve Your Seat
Aug 22 - 25
(4 Days)
9:00 AM - 4:30 PM EDT
Rockville, MD / Online (AnyWare)
Reserve Your Seat
Aug 29 - Sep 1
(4 Days)
9:00 AM - 4:30 PM EDT
Toronto / Online (AnyWare)
Reserve Your Seat
Sep 5 - 8
(4 Days)
9:00 AM - 4:30 PM EDT
Ottawa / Online (AnyWare)
Reserve Your Seat
Oct 10 - 13
(4 Days)
9:00 AM - 4:30 PM EDT
Herndon, VA / Online (AnyWare)
Reserve Your Seat
Nov 6 - 9
(4 Days)
9:00 AM - 4:30 PM EST
New York / Online (AnyWare)
Reserve Your Seat
Dec 19 - 22
(4 Days)
9:00 AM - 4:30 PM EST
Rockville, MD / Online (AnyWare)
Reserve Your Seat
Jan 23 - 26
(4 Days)
9:00 AM - 4:30 PM EST
Toronto / Online (AnyWare)
Reserve Your Seat
Feb 20 - 23
(4 Days)
9:00 AM - 4:30 PM EST
Ottawa / Online (AnyWare)
Reserve Your Seat
Apr 10 - 13
(4 Days)
9:00 AM - 4:30 PM EDT
Herndon, VA / Online (AnyWare)
Reserve Your Seat
May 8 - 11
(4 Days)
9:00 AM - 4:30 PM EDT
New York / Online (AnyWare)
Reserve Your Seat
Guaranteed to Run
Private Team Training
Enrolling at least 3 people in this course? Consider bringing this (or any course that can be custom designed) to your preferred location as a private team training.
For details, call 1-888-843-8733 or Click Here »
Tuition
Standard
Government
In Classroom or
Online
Standard
$2990
Government
$2659
Private Team Training
Course Tuition Includes:
Training Hours
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:
- Have a record of your growth and learning results
- Bring proof of your progress back to your organization
- Earn credits toward industry certifications (if applicable)
Enhance Your Credentials with Professional Certification
Learning Tree's comprehensive training and exam preparation guarantees that you will gain the knowledge and confidence to achieve professional certification and advance your career.
Earn 23 Credits from NASBA
This course qualifies for 23 CPE credits from the National Association of State Boards of Accountancy CPE program. Read more ...