Change Academy
Training Courses
Training Services Public Training Programme Leadership and Personal Development Systems and Office Applications Project Management
About Contact Podcast
VBA in Excel Part 1 training course hero image – Learn the fundamentals of Visual Basic for Applications in Excel.

VBA in Excel - Part 1

Following on from the Macros course look at how you can write your own Visual Basic code within Excel to fully automate tasks and save time.

Course overview

Duration: 2 days (13 hours)

Our VBA in Excel course is an introduction to using the Visual Basic for Applications language for programming in Excel. It looks at structures, syntax and coding standards.

This course is designed for existing experienced users of Excel who can record and run macros and those who have dabbled in VBA but would like some formal training and help to put some structure to their code.

Objectives 

By the end of the course you will be able to:

  • Write visual basic procedures
  • Create event and general procedures
  • Use commands from the Excel data model
  • Use statements and functions
  • Use a selection of debugging tools
  • Create and use variables and constants
  • Use different types of loops
  • Create an Excel user form

Content

The VBA environment  
  • Project explorer
  • Excel objects
  • Modules
  • Properties window
  • Code window
Code structure
  • Code structure
  • Navigating within your code
  • Adding comments
  • Using WITH
  • Steps to creating a VBA procedure
Procedures 
  • Sub procedures
  • Event procedures
  • Calling procedures
The Excel data model 
  • Workbook commands
  • Worksheet commands
  • Excel selection methods
  • Data manipulation commands
Debugging 
  • Using breakpoints
  • Stepping through code
  • The immediate window
  • The watch window
  • The locals window points
Variables and Constants 
  • Declaring variables
  • Declaring multiple variables
  • Variable data types
  • Concatenation
  • Scope of variables
  • Constants
  • Declaring constants
  • Using constants
  • Scope of constants
Looping 
  • Do while loops
  • Do until loops
  • For next loops
Conditional Statements
  • IF statement
  • SELECT CASE statement
  • Comparison statements
  • Logical operators
Creating a User Form
  • Form layout
  • The control toolbox
  • Naming conventions
  • Adding objects
  • Naming objects
  • Captions
  • Displaying the form
Object properties
  • Object properties
  • Setting properties at design time
  • Setting properties at run time
Interconnectivity between the user form and Excel
  • Comparing values
  • Transferring information
  • Running code

Testimonials

“Very thorough training and easy to follow, with plenty of practical exercises to have a go at. Susan is an excellent trainer – I have attended multiple Excel training courses with her and they have all been really helpful. I now feel confident writing basic code, understanding the VBA ‘language,’ and debugging when things go wrong.”

Olivia Knox, Accounts Receivable Supervisor, TotalEnergies

“Yes, this was a great course to get started with VBA for beginners. Susan was excellent at explaining concepts and showing different ways to write code for each task, making it easy to understand. Getting to learn why and when we use VBA was crucial, especially as I hadn’t done any coding before. The pace was a little slow at times, but I can see why – it ensured everyone could follow the topic.”

Aamir Patel, Senior Pricing Project Analyst, TotalEnergies

“A very useful and practical course for those wishing to enhance their Excel understanding. I enjoyed the flow and found the practice exercises particularly helpful in cementing the subject in my mind. Susan’s knowledge and assistance were excellent throughout, making the course easy to follow. I actually found the virtual format even better than in person, as I was more focused and able to get the most out of the learning.”

Barry Clarke, Process Engineer, Tokyo Electron Magnetic Solutions

Frequently Asked Questions

Get in Touch

Still have questions about this course?

Click Enquire Now and our team will share full details on content, dates, and pricing — and help you decide if it’s the right fit for you or your organisation.

Enquire Now

Related Courses

Excel – Working with Macros

Learn how to use Macros in Excel to automate your work and start to see the power these can give you.

View the course outline
VBA in Excel – Part 2

Expand your VBA knowledge further and learn some of the more advanced coding features.

View the course outline
Excel Power Query and Power Pivot

Learn how to work with and connect multiple data sets to effectively analyse and report on data.

View the course outline

Explore More Training Options

Public Training Programme

Explore our current selection of public courses, available as convenient and cost-effective virtual sessions.

Engage with expert instructors and a diverse peer group in an interactive, online learning environment.

Ideal for those valuing flexibility and affordability, our public courses are ideal where you only have small numbers requiring training and offer training from the comfort of your home or office.

Check Public Dates

Full Training Catalogue

We deliver a wide range of training across Leadership, Personal Development, Project Management, and IT applications. Many organisations choose us because they can source both technical and people-focused training from one trusted provider.

Courses can be tailored to your organisation’s needs, making it easier to upskill teams consistently across different areas. Whether you want to build management capability, strengthen project delivery, or boost everyday software skills, you’ll find relevant options in our catalogue.

View our Leadership and Personal Development Course Catalogue
View our Systems and Office Applications Course Catalogue
View our Project Management Course Catalogue