Tel: 01423 534630 • Email: info@tts-uk.com
Designed for Excel 365, 2019, 2016, 2013, 2010
This course is suitable for advanced users of Microsoft Excel looking to further increase their knowledge of VBA.
A beginners knowledge of Microsoft Excel VBA is required, or completion of our Excel VBA Introduction course.
By the end of the course the delegate will be fully competent in the fundamentals of VBA, including working with functions, understanding objects, using expressions, variables and intrinsic functions.
This includes mastering forms and controls, and building user defined functions.
There will also be discussion of techniques for improving and optimizing code.
How and why you should declare variables
Determining which data type to use
Public v Private scope
Using variables to trap errors
Using the Locals window to observe variables
Writing your own User Defined Functions (UDFs)
Working with multiple arguments
Using your function in Excel
Displaying a message
Adding a yes / no user choice
Getting feedback from the end user
Defining VBA’s Error Trapping Options
Capturing Errors with the On Error Statement
Determining the Err Object
Coding an Error-Handling Routine
Using Inline Error Handling
Drawing UserForms
Setting UserForm properties, events and methods
Using text boxes, command buttons, combo boxes and other controls
Formatting controls
Applying code to controls
How to launch a form in code