Since 1988, Blue Novation has designed and delivered exceptionally high standard training solutions to businesses in both the private and public sector. The quality of training we deliver is of paramount importance to us.
Our approach ensures that delegates enjoy their training whilst gaining the additional skills and knowledge to become more productive in the workplace.
Introduction to Excel VBA
This course will show delegates how to use the Visual Basic for Applications (VBA) programming language to simplify and automate many of the repetitive tasks that are part of spreadsheet development.
using the macro recorder • running macros via worksheet or toolbar buttons • relative and absolute cell references • options for storing a macro
Visual Basic Editor (VBE) Window
familiarisation with the VBE window • excel objects, user forms & modules • procedures, keywords, statements & comments • customising the VBE window
Creating and Modifying VBA Code
making long statements readable • using message boxes to interact with the user • using input boxes to get information from the user
Working with Worksheets and Cells
navigating around worksheets • editing & formatting cells • moving around lists of data • working with named ranges
Introducing Functions and Variables
variables and variable types • using a naming convention for your variables • using built-in worksheet functions
Decision Making within VBA Procedures
using If Then Else statements • using Select Case statements
Looping Through Data
using Do While or Do Until statements • exploring the use of the For Next statement
De-Bugging your Code
break mode • stepping through code • using auto data tips, call stack, expressions • using the immediate window, local window
using “controls” on the worksheet • setting the properties of controls • linking controls to the worksheet
Working with Workbooks
opening other workbooks with re-usable code • navigating between different workbook • saving a workbook file
Creating Re-usable Code
passing arguments to a procedure • exploring the benefits of re-usable code
Handling Errors within your Code
trapping errors • adding code to handle the errors • determining what error has occurred • exiting from the error handling code
Variables and their scope and lifetime
testing the content of a variable • local, module and static variables • global and private variables • using constants
Working with Data
manipulating data contained within a single string • manipulating dates
Creating User Defined Functions
creating a simple function • creating a function for a more complex formula you use frequently
how to create simple custom forms in Excel • adding controls to a user form • adding code to respond to events
Good Coding Guide
Follow on Course
Special Offer – 10% Discount on Excel VBA!
21st – 22nd May 2019 – Spaces available
23rd – 24th Jul 2019 – Spaces available
Scheduled Course Fee
£470 + VAT
The 2-day Introduction to VBA is for people with a good working knowledge of Excel. No prior knowledge of Excel macros or VBA is required.
Scheduled course · Private course · tailored · 1 to 1 (all instructor led)
A comprehensive course manual provides support throughout the course and upon your return to the office.
Steve Roberts, Group Reporting Analyst
Tahmina Miah, Finance Assistant
Not found the course you are looking for?