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.
Duration:
3 Days
Cost:
£695 + VAT
Course Date
Location
Demand led
Call to request dates
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
Variables
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
