VBA in Excel - Part 1
Learn the fundamentals of Visual Basic for Applications (VBA) and start automating real Excel tasks. This practical Part 1 course shows you how to write clean, structured code that saves time, reduces errors, and gives you more control over your spreadsheets.
In this course, you will learn how to:
- Write your first VBA procedures with confidence
- Automate repetitive tasks and reduce manual errors
- Understand variables, loops, and core programming logic
- Use debugging tools to fix issues quickly
- Create simple user forms to interact with your workbook
Who is this course for?
Confident Excel users who want to start automating tasks with VBA. Ideal for analysts, administrators and managers who work with regular reports, repetitive processes or large datasets.
Enquire NowFrequently Asked Questions
Who is this Excel VBA Part 1 training course for?
What will I learn on the Excel VBA Part 1 course?
Do I need any experience with programming before joining?
How is the Excel VBA Part 1 training delivered?
Will the course include hands-on practice?
What support do I receive after the course?
Course Outline
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
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 NowRelated 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.
VBA in Excel – Part 2
Expand your VBA knowledge further and learn some of the more advanced coding features.
Excel Power Query and Power Pivot
Learn how to work with and connect multiple data sets to effectively analyse and report on data.
Additional Insights
Continue your learning with related articles, case studies, and podcast episodes that explore how these skills are applied in real-world contexts.
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 DatesFull 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.
