Microsoft Excel VBA Course
Automate Excel tasks and build powerful custom tools using VBA on this two-day practical course.
Covering macros, the Visual Basic Editor, loops, error handling and interactive user forms.
Automate Excel tasks and build powerful custom tools using VBA on this two-day practical course. Covering macros, the Visual Basic Editor, loops, error handling and interactive user forms.
-
Expert Trainers Experienced industry expert
- Class Size 1–8 in person or 1–6 online
- Support 28 days free helpdesk
- Cancellation 7 day cancellation
- Certificate Certificate of attendance
- Volume Discounts Save with Learning Pots
Microsoft Excel VBA Course
This VBA and Excel course will unlock the power of coding in Excel.
Learn how to create dynamic macros to automate repetitive tasks, streamline data processing, and enhance productivity.
Dive into the world of Visual Basic for Applications (VBA) and gain the skills to write custom code that extend Excel's functionality.
Discover the art of coding with VBA as you build interactive applications, manipulate data, and control Excel objects.
This course will equip you with the knowledge and tools to harness the full potential of VBA in Excel.
This course requires solid Excel foundations — our Microsoft Excel Introduction and Microsoft Excel Advanced courses are the recommended starting points.
Private & team training
Request a quote for Microsoft Excel VBA
This course isn’t on the public schedule right now. Request a quote and we’ll come back with dates, pricing, and delivery options — at our centre, live online, or at your venue.
Course Outline
Getting Started
Displaying the Developer Tab
Recording and running a Macro
Macro-Enabled Workbooks
Using the Visual Basic Editor
The Development Environment
Understanding Macro Security
Working with Procedures and Functions
Understanding Modules
Understanding Procedures
Calling Procedures
Creating a Function Procedure
Working with the Code Editor
Understanding Objects
Objects and Collections
Working with Properties
Using the With Statement
Creating an Event Procedure
Using Expressions, Variables, and Intrinsic Functions
Understanding Expressions and Statements
Declaring Variables
Understanding Data Types
Using Intrinsic Functions
Understanding Constants
Declaring and using Object Variables
Controlling Program Execution
Control-of-Flow Structures
Working with Boolean Expressions
Different types of Control-of-Flow structures
Guidelines for use of Control-of-Flow Structures
Working with Forms and Controls
Working with UserForm Properties, Events and Methods
Working with different Controls
SettingControl Appearance
Populating a Control
Adding Code to Controls
Launching a Form in Code
Handling Errors
Understanding Error Handling
Writing an Error-Handling Routine
Working with Inline Error Handling
Questions and answers
This course is only available as a private course. This allows you to choose the dates for your training. And, if you wish, we can tailor the content for you or your team. Please contact us for more details.
Who is this course for?
For experienced Excel users who want to automate tasks and build custom tools using VBA macros. Requires our Excel Advanced course or equivalent working knowledge.
Great Teacher and teaching approach, loved the dynamic and learned so much.
Great trainer, very knowledgeable and approachable. Well-paced and catered to the ability of the participants. Regular breaks to keep engag…
Really thorough and could relate to struggles and correct some errors made
Very interactive & trainer tailored the course to suit our needs
Tom was fantastic, he tailored the course to suit what we were looking for meaning we will be able to use this in our day to day lives and…
Really very thorough, very approachable and an enjoyable course
Very thorough referencing and alternative working options
Very interactive learning style, tutor is clearly very knowledgeable & friendly
Swipe for more
Read course reviewsWho attends?
Career Progressives
Professionals who wish to develop skills for their current role and companies who believe in developing their talent.
Career Changers
People seeking opportunities which require new skills. Industry relevant training for those pursuing a new role.
Graduates
Certified courses for those who have earned their theoretical stripes, but need to prove capability to future employers.
Further Reading
Why You Should Learn Microsoft Power BI?
Microsoft Power BI turns raw data into clear, actionable insights.
Ways To Make Your PowerPoint Presentation Stand Out
Looking to impress your audience with amazing Powerpoint design presentation skills?
8 Tips To Make You An Excel Expert
Learning Excel is always useful whether you work with data or in finance.