Microsoft Visual Basic for Excel – 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

The use of Visual Basic in Excel unlocks the true power of this application. Create powerful yet user friendly applications that will be capable of running critical business processes.

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

Those who require the fundamental skills to create useful and powerful VB applications.

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

Work with Command and Function procedures
Work with Objects
Create User Forms
Set options within Excel
Observe event handling codes
Debug Code

Course Content

Introduction to the VBA environment
Objects
Decision Making Code
Code that repeats
Using VBA to display information
Reading and setting Excel’s options
Using Forms
Event handling code
User defined menus & toolbars
Add in Applications
Breakpoints and watches

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.