-
-
Cart
There are no items in your cart. Continue shopping on our Course Directory page.
SUBTOTALPay now -or- pay later
Pay by credit card at checkout
-or- pay later by invoice, as always.
-
Introduction to VBA Programming Training
Level: Intermediate
Rating:
4.75/5 Based on 104 Reviews
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.
Key Features of this VBA Training:
- After-course instructor coaching benefit
- Learning Tree end-of-course exam included
- After-course computing sandbox included
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
Choose the Training Solution That Best Fits Your Individual Needs or Organisational Goals
LIVE, INSTRUCTOR-LED
In Class & Live, Online Training
- 4-day instructor-led training course
- After-course instructor coaching benefit
- Learning Tree end-of-course exam included
TRAINING AT YOUR SITE
Team Training
- Bring this or any training to your organisation
- Full - scale program development
- Delivered when, where, and how you want it
- Blended learning models
- Tailored content
- Expert team coaching
Customize Your Team Training Experience
CONTACT USSave More on Training with Learning Tree Training Vouchers!
Our flexible, easy-to-redeem training vouchers are available to any employee within your organisation. For details, please call 0800 282 353 or chat live.
In Class & Live, Online Training
Note: This course runs for 4 Days *
*Events with the Partial Day Event clock icon run longer than normal but provide the convenience of half-day sessions.
-
7 - 10 Dec 9:00 AM - 4:30 PM GMT Online (AnyWare)
Reserve Your Seat -
15 - 18 Mar 9:00 AM - 4:30 PM GMT Online (AnyWare)
Reserve Your Seat -
21 - 24 Jun 9:00 AM - 4:30 PM BST Online (AnyWare)
Reserve Your Seat -
6 - 9 Sep 9:00 AM - 4:30 PM BST Online (AnyWare)
Reserve Your Seat -
9 - 12 Mar 2:00 PM - 9:30 PM GMT Herndon, VA / Online (AnyWare)
Reserve Your Seat -
4 - 7 May 2:00 PM - 9:30 PM BST New York / Online (AnyWare)
Reserve Your Seat -
7 - 10 Sep 2:00 PM - 9:30 PM BST Herndon, VA / Online (AnyWare)
Reserve Your Seat
Guaranteed to Run
When 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 Event
Learning 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.VBA Introduction Course Information
-
Recommended Experience
- Familiarity with Microsoft Office applications
-
Software
- This course is applicable to all versions of Office, from 2007 to 2016
VBA Introduction 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
- Utilising the FileDialog object and Dialogs collections
Creating customised 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
Team Training
VBA Introduction Training FAQs
-
Can I learn VBA programming online?
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.
-
What versions of Microsoft Office is this course applicable for?
This course is applicable to all versions of Office, from 2007 to 2016.
Related VBA Training
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
Your Training Comes with a 100% Satisfaction Guarantee!*
*Partner-delivered courses may have different terms that apply. Ask for details.