Call Me Back

Page 1

Looking for more information?

Complete your details below and we'll call you back



Course Type


Price Per Delegate

£895 +VAT
Public Scheduled Course

Price Per Course

£2,945 +VAT
On-Site at Customer Premises, Max 10 Delegates


3 Days

Full/Part Time

Part Time


SmartStyle Training

Book course

This course is intended for users who need to exploit Excel Visual Basic for Applications to automate tasks and use and create functionality not found in the standard Excel interface.

Objectives: At the end of the course users will be able to understand and create VBA code. You will be able to create procedures, user-defined functions and forms to help automate Excel spreadsheets for End Users.

Prerequisites: An advanced understanding of creating spreadsheets and manipulating data in Excel.

Download Outline (PDF)

An Introduction to Macros
  • Recording & Running Macros
  • Adding Macros to the Excel Interface
  • Setting Macro Protection Levels
Getting Started with Visual Basic Editor
  • Exploring the Visual Basic Editor
  • Understanding VBA Procedures
  • Commenting & Editing VBA Code
Objects & Object-Oriented Programming
  • Understanding Objects & Dot Syntax
  • Referencing Cells with the Range Object
  • Organising Code using With...End With
Editing Features
  • Running Code in the Immediate Window
  • Completing Code with Auto Lists
Message Boxes
  • Creating & Customising Message Boxes
  • Receiving Information from Message Boxes
  • Understanding & Naming Variables
  • Methods of Declaring Variables
  • Defining Variable Data Types
  • Declaring & Using Constants
  • Assigning Values & Objects to Variables
Input Boxes
  • Creating Input Boxes to Receive User Data
  • Understanding & Customising Input Boxes
Writing Procedures
  • Calling Procedures from Different Locations
Function Procedures
  • Understanding and Using Intrinsic Functions
  • Writing User-Defined Functions
  • Using User-Defined Functions in VBA & the Excel Interface
Conditional Control Structures
  • Controlling Program Flow Using IF Structures
  • Using Select Case Structures
Looping Control Structures
  • Repeating Code Using Loops
  • Definite Loops
  • Indefinite Loops
Controls Dialog Boxes and Forms
  • Creating User Forms
  • Using Form Controls
  • Adding VBA Code to User Forms
Using Pivot Tables
  • Understanding Pivot Tables
  • Creating Pivot Tables with VBA
  • Manipulating Pivot Tables with VBA
Debugging & Error Trapping
  • Identifying Error Types
  • Reducing Errors in Code
  • Checking Code with Debugging Tools
  • Writing Code to Handle Errors

Enquire about a course

Fill in your information to apply for this course. The information you provide on this application form may be passed to funding bodies, in line with the Data Protection Act 1998, and may be shared with other training providers and possible employers for the purpose of administration, statistical and research purposes.