Home Specialist skills Technology and Software Excel Visual Basic for Applications (VBA) Intermediate
Excel Visual Basic for Applications (VBA) Intermediate
-
Gain a good understanding of the major components of VBA
-
Learn how to use VBA to communicate with other Office applications such as Word
-
Work with data from database applications such as Access and manipulate and present the data
Overview
Off the shelf (OTS)
By the end of the course the participant 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 optimising code.
Delivery method
Virtual
Course duration
6 hours
Competency level
Expert
Spark login – Alpha testing