- Courses/
- Microsoft Excel/
- Excel VBA Introduction/
Microsoft Excel VBA Introduction Training Courses
Excel VBA Introduction
Boost your Excel skills with our Future Savvy 2-day Excel VBA course. Learn to automate spreadsheets, record macros, edit VBA code, and create custom forms. Perfect for gaining control and developing dynamic applications. Unlock the potential of workbooks and worksheets with hands-on guidance. Ideal for simplifying repetitive tasks and enhancing your Excel capabilities.
Virtually Online Or On-Site
2 Days
Next Running:
11th November
Expert Trainers
Small Class Sizes
Rated 4.8/5 by learners
Money-Back Guarantee
Why Choose Training with
Future Savvy?
Trusted by top UK Organizations
From NHS teams to FTSE 100 companies, over 1,000 professionals have trusted Future Savvy to upskill their teams with results-driven training.
Real Experts, not Just Instructors
Our courses are delivered by seasoned professionals with real-world experience using the tools they teach, not just theory, but practical insight.
Small Class Sizes for Big Impact
Our class sizes are intentionally small, usually no more than 6, to ensure every learner gets personal attention and time with the trainer.
Hands-on, Interactive Learning
You won’t just sit and watch, you'll get stuck in with practical exercises, real scenarios, and immediate feedback from your trainer.
Ongoing Support, even after the Course
Have questions after the training? We’re still here. All delegates get unlimited post-course email support at no extra cost.
100% Satisfaction Guarantee
We stand by the quality of our training. If you're not completely satisfied, we'll give you a full refund.
Course Information —Excel VBA Introduction.
Course Information
Get ready to take your Excel applications to the next level by harnessing the power of the VBA language.
This Future Savvy instructor-led Excel VBA course will help you gain more control over your spreadsheets by using VBA. Our instructors will show you how to develop more dynamic Excel applications for other users. From introductory concepts to advanced developer topics, our instructors will guide you through every aspect of Excel VBA.
The Future Savvy Excel VBA course is the perfect introduction to VBA as you'll learn how to work with the key objects and uncover the best ways to gain access to workbooks, worksheets, and more.
Course requirements
Delegates should have proficient knowledge of Microsoft Excel or should have attended all of the following courses (or similar) prior to this course:
By the end of the 2-day instructor-led Excel VBA Introduction course, you’ll know how to work with procedures and functions, debug code and work with forms and controls.
What you will learn
This hands-on Excel VBA course helps you to create automated spreadsheets for all those repetitive tasks you hate doing. Our 2-day VBA course will teach you to simplify complex tasks that need to be performed on a regular basis, so the end of the course, users will be able to record and run macros, edit the VBA code, build in looping structures and create custom forms.
All with our 100% Money-Back Guarantee and Unlimited Email Support.
1
Getting Started
- Introducing Visual Basic for Applications
- Displaying the Developer Tab
- Recording a Macro
- Saving a Macro-Enabled Workbook
- Running a Macro
- Editing a Macro in the Visual Basic Editor
- Understanding the Development Environment
- Using Visual Basic Help
- Understanding Macro Security
2
Working with Procedures and Functions
- Understanding Modules
- Creating a Standard Module
- Understanding Procedures
- Creating a Sub Procedure
- Calling Procedures
- Using the Immediate Window to Call Procedures
- Creating a Function Procedure
- Naming Procedures
- Working with the Code Editor
3
Understanding Objects
- Understanding Objects
- Navigating the Excel Object Hierarchy
- Understanding Collections
- Using the Object Browser
- Working with Properties
- Using the With Statement
- Working with Methods
- Creating an Event Procedure
4
Using Expressions, Variables, and Intrinsic Functions
- Understanding Expressions and Statements
- Declaring Variables
- Understanding Data Types
- Working with Variable Scope
- Using Intrinsic Functions
- Using Intrinsic Constants
- Using Message Boxes
- Using Input Boxes
- Declaring and Using Object Variables
5
Controlling Program Execution
- Understanding Control-of-Flow Structures
- Using the If...End If Decision Structures
- Using the Select Case...End Select Structure
- Using the Do...Loop Structure
- Using the For...To...Next Structure
- Using the For Each...Next Structure
- Guidelines for use of Control-of-Flow Structures
6
Working with Forms and Controls
- Understanding UserForms
- Using the Toolbox
- Working with UserForm Properties, Events,and Methods
- Understanding Controls
- Setting Control Properties in the Properties Window
- Working with Control Appearance
- Setting the Tab Order
- Populating a Control
- Adding Code to Controls
- Launching a Form in Code
7
Debugging the Code
- Understanding Errors
- Using Debugging Tools
- Setting Breakpoints
- Stepping through Code
- Using Break Mode during Run mode
- Determining the Value of Expressions
8
Handling Errors
- Understanding Error Handling
- Understanding VBA's Error Trapping Options
- Trapping Errors with the On Error Statement
- Understanding the Err Object
- Writing an Error-Handling Routine
- Working with Inline Error Handling
UpcomingCourses
Tuesday11th November
2 Days
£595.00
EX. VAT
Thursday19th February
2 Days
£595.00
EX. VAT
Thursday21st May
2 Days
£595.00
EX. VAT
Thursday27th August
2 Days
£595.00
EX. VAT
Thursday26th November
2 Days
£595.00
EX. VAT
Private courses.
We’ll help you meet your company training needs with instructor-led business skills and IT training courses, or your money back. Take courses in our UK classrooms or online - it’s your choice!
Tailored
Post Course Support
Cost Effective
You’re in Good Company
You’re in Good Company
Over 1,000 professionals from industry-leading brands have chosen Future Savvy for their training needs.
RelatedCourses
Next Running:
1st September
Excel Introduction
Gain essential Excel skills with our 1-day beginner course. Learn how to use Excel efficiently for business, perform calculations, create and use formulas, modify and format worksheets, and style data for greater impact. This training course is ideal for understanding and analysing your organisation's data to make informed business decisions.
Virtually Online Or On-Site
1 Day
Next Running:
3rd September
Excel Intermediate
Enhance your Excel skills with our 1-day Excel Intermediate course. You will learn advanced formulas, named ranges, data analysis, and conditional formatting. An ideal choice if you already have basic Excel knowledge. This course will empower you to make data-driven decisions.
Virtually Online Or On-Site
1 Day
Next Running:
5th September
Excel Advanced
Elevate your Excel prowess in our 1-day Excel Advanced training course. Master task automation, complex formulas, PivotTables, and data visualisation. Suited for experienced users, this course boosts your ability to analyse and present data.
Virtually Online Or On-Site
1 Day
Registered England and Wales: 11477692 VAT Number: GB 3123317 52All trademarks are owned by their respective owners. Click here for details.
