0345 4506120

Microsoft Excel VBA Introduction


This course covers 2007, 2010, 2013 and 2016 versions


This is a one-day training course structured into 5 modules. Maximum class size for Microsoft Excel courses is 6 delegates, which ensures that attendees get adequate time for personal attention from the instructor.


The course is designed for existing, experienced users of Excel 2007, 2010, 2013 or 2016 who need to use VBA to automate their spreadsheets. Delegates should therefore have a solid grounding in, and understanding of, Microsoft Excel to a high level.   Familiarity with the content of the Advanced course would be a minimum requirement although the Professional level is ideal.


Learning Objectives


This intensive, hands-on one-day course has been designed for people who wish to learn the basics of the Excel VBA programming language, get used to the concepts and methods of VBA programming, and understand (and use) the relevant techniques.

Course Content

MODULE 1:  Recording and Running Macros in Excel
Learning outcomes:
Create simple macros using the macro recorder and run them from shortcuts or buttons on the ribbon
Topics covered:
  • Setting Excel Macro Options
  • Record and Run Simple Macros
  • Assign Macros to the Quick Access Toolbar
MODULE 2:  Introduction to the Excel VBA Editor
Learning outcomes:
Use the VBA Editor to navigate projects and explore object properties. Create, copy and import/export modules
Topics covered:
  • Starting the Visual Basic Editor
  • Using the Project Explorer
  • Using the Properties Window
  • Creating, Importing and Exporting Modules
  • Explore Recorded Macros
MODULE 3:  Creating Procedures and Functions
Learning outcomes:
Create simple macro procedures in code that use variable to store data and communicate with the user
Topics covered:
  • Creating Sub and Function Procedures
  • Declare and Use Variables
  • Displaying Message to the User
  • Getting Input from the User
MODULE 4:  Working with the Excel Object Model
Learning outcomes:
Explore a variety of ways our code can manipulate data within cells, create and navigate around worksheets and workbooks
Topics covered:
  • Understanding Objects, Properties and Methods
  • Referencing Cells and Ranges
  • Gathering Cell and Range Information
  • Using the Offset Method
  • Using the Resize Method
  • Using With Blocks
  • Referencing Workbooks and Worksheets
MODULE 5:  Controlling Program Flow
Learning outcomes:
Using decision making and looping structures to control the way your program works
Topics covered:
  • Using the IF Statement
  • Using the Select Case Statement
  • Using For Next Loops
  • Using Do Loops
  • Using For Next Loops

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the requested service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.


Our Customers Include