Visual Basic for Excel Advanced – VBA

Course Duration is 2 Days

£1,190.00 Plus VAT

Delivery Method

Face To Face Delivery  Virtual Delivery One To One Coaching Closed Group Course Public Course

Business Benefit

Building on the Introduction course this takes the user through more detailed commands and options in VBA allowing the user to create applications with custom front ends and add-ins.

How to Book

If you are interested in booking this course, then please select an available date and then click book now to complete the booking. Can’t see a suitable date contact us on [email protected] and we can discuss specific date requirements.

Who Should Attend

Anyone wishing to take their VBA knowledge beyond that of the basic course. Basic VBA knowledge is assumed.

Learning Outcomes – by the end of this course you will be able to…

Construction of an application
Create Add-ins
Understand Class modules
Combine external applications and files
Programmatically create Charts
Create Pivot tables in VBA

Course Content

Review of user forms
Workbook and Worksheet events
Application of dynamically populated List items
Use of form templates to dynamically manipulate form display contents at runtime
Assigning macros to ribbon tabs (toolbars)
Creation and maintenance of menus
Creation of add-in workbook
Application of ribbon tab to invoke and control an add-in
Application of Excel options window to activate an add-in
Overview of class module versus program module
Creation of property and method procedures  in classes
Use and manipulation of class modules
Use of data from other Excel files
Use of object hierarchies in other Microsoft Office applications
Data storage in the Windows registry
Creation of Charts in VBA
Creation and manipulation of Pivot tables

Embedding

These follow up coaching sessions help support your colleagues to embed their learning during their skills transfer period.  Applying new skills and changing behaviour takes effort and practice.  After attending a training course many colleagues will find they need support through this transition.  EQV can provide that support with follow up coaching sessions to help embed the learning.

Embedding coaching sessions can be delivered in 90 minute and half day durations.  The facilitator will work with the group to capture feedback about challenges and how to overcome them ensuring success going forward.

Having a formal embedding coaching session will not only increase the success of the skills transfer period but helps create a platform of motivation, inclusivity and commitment within the group.