Microsoft Excel VBA Training – Level 3 (2 days)

Our Excel VBA Level 3 course is designed for experienced Excel VBA developers who are familiar with working with the Excel object model.

Developing applications

Types of applications, Types of end-user, Analysing end-user needs, Planning an application, Planning the user interface

Working with events

Overview of event types, Event-handler procedures, Workbook events, Worksheet events, Chart events, UserForm events, Activate event, Save events, Change events, Focuse events, Click events

Creating Add-ins

Add-ins defined, Creating an add-in, Installing and add-in, Controlling add-ins with VBA, Add-ins collection, Add-in properties, Add-in events, Potential problems with add-ins

Customising the Ribbon

The customui Folder and File, Creating a Tab and a Group, Adding a Control to a Ribbon, Accessing the File Structure, Understanding the RELS File, Renaming an Excel File and Opening a Workbook, Using Images on Buttons, Using Microsoft Office Icons on a Ribbon, Adding Custom Icon Images to a Ribbon

Data Visualizations and Conditional Formatting

VBA Methods and Properties for Data Visualizations, Adding Data Bars to a Range, Adding Color Scales to a Range, Adding Icon Sets to a Range, Specifying an Icon Set, Specifying Ranges for Each Icon, Creating an Icon Set for a Subset of a Range, Using Two Colors of Data Bars in a Range, Using Other Conditional Formatting Methods, Formatting Cells That Are Above or Below Average, Formatting Cells in the Top 10 or Bottom 5

File manipulation

Opening a text file, Writing a text file, Importing data from a text file, Searching for text in files, Verifying if a file exists, Listing all files in a given folder

Class modules

Class modules defined, When to use class modules, Creating a class module, Property procedures, Method procedures

Excel VBA Training On-Site UK-Wide

The fee for running in-house Excel VBA courses in Colchester is £795, per day.
The cost for running customized Excel VBA courses in Luton is £795, per day.
Our fee for delivering customized Excel VBA training in Tyneside is £795, per day.
The charge for running customized Excel VBA training in Liverpool is £795, per day.
Our price for delivering on-site Excel VBA courses in Medway Towns is £795, per day.
The fee for running customized Excel VBA training in Doncaster is £795, per day.
The fee for running customized Excel VBA training in Exeter is £795, per day.
Our charge for delivering on-site Excel VBA courses in Farnborough/Aldershot is £795, per day.
The charge for running customized Excel VBA training in Greater Manchester is £795, per day.
Our charge for delivering Excel VBA courses in Chesterfield is £795, per day.
Our price for supplying on-site Excel VBA courses in Reading is £795, per day.
Our price for delivering on-site Excel VBA courses in Blackpool is £795, per day.
Our fee for delivering in-house Excel VBA courses in High Wycombe is £795, per day.
The charge for running Excel VBA courses in Chelmsford is £795, per day.
The fee for running on-site Excel VBA training in Edinburgh is £895, per day.
Our price for delivering in-house Excel VBA courses in Oxford is £795, per day.
Our price for running on-site Excel VBA training in The West Midlands is £695, per day.
The fee for running on-site Excel VBA training in Telford is £695, per day.
The cost of supplying on-site Excel VBA courses in Accrington/Rossendale is £795, per day.
Our charge for supplying Excel VBA courses in Sunderland is £795, per day.
Our price for supplying in-house Excel VBA courses in Derby is £695, per day.
Our price for delivering customized Excel VBA courses in Basingstoke is £795, per day.
Our price for delivering customized Excel VBA courses in Eastbourne is £795, per day.
Our fee for delivering on-site Excel VBA training in Northampton is £795, per day.
The fee for running customized Excel VBA training in Ireland is £895, per day.
The charge for running in-house Excel VBA courses in Preston is £795, per day.
Our price for running Excel VBA courses in Sheffield is £795, per day.
Our price for running customized Excel VBA training in Plymouth is £795, per day.
Our price for supplying in-house Excel VBA courses in Slough is £795, per day.
Our charge for supplying on-site Excel VBA training in Newport is £795, per day.
The fee for running customized Excel VBA courses in Torquay is £795, per day.
Our price for delivering customized Excel VBA courses in Burnley is £795, per day.
Our fee for delivering customized Excel VBA courses in Ipswich is £795, per day.
The fee for running on-site Excel VBA training in West Yorkshire is £695, per day.
Our price for supplying Excel VBA courses in Dundee is £895, per day.
Our fee for delivering customized Excel VBA courses in Cardiff is £795, per day.
Our fee for delivering Excel VBA courses in Bristol is £795, per day.
The fee for running customized Excel VBA training in Norwich is £695, per day.
Our charge for supplying on-site Excel VBA courses in Birkenhead is £795, per day.
Our charge for delivering customized Excel VBA courses in Coventry is £695, per day.
Our fee for delivering on-site Excel VBA courses in Warrington is £795, per day.
Our price for delivering in-house Excel VBA courses in Mansfield is £795, per day.
The fee for running on-site Excel VBA courses in Greater Glasgow is £895, per day.
The charge for running customized Excel VBA courses in Lincoln is £695, per day.
Our charge for delivering customized Excel VBA training in Wigan is £795, per day.
The cost for running in-house Excel VBA courses in Poole is £795, per day.
The fee for running on-site Excel VBA courses in Worcester is £795, per day.
The charge for running customized Excel VBA courses in Stoke-on-Trent is £695, per day.
Our charge for supplying on-site Excel VBA courses in Maidstone is £795, per day.
Our price for running customized Excel VBA training in Nottingham is £695, per day.
Our price for supplying Excel VBA courses in Basildon is £795, per day.
The cost for running customized Excel VBA courses in Hastings is £795, per day.
Our charge for delivering customized Excel VBA courses in Swindon is £795, per day.
Our price for delivering customized Excel VBA training in Brighton and Hove is £795, per day.
The cost of supplying Excel VBA courses in Cheltenham is £795, per day.
Our price for running on-site Excel VBA courses in Teesside is £795, per day.
Our price for supplying customized Excel VBA training in Cambridge is £695, per day.
The charge for running customized Excel VBA courses in Thanet is £795, per day.
The charge for running customized Excel VBA courses in Birmingham is £695, per day.
The cost of supplying on-site Excel VBA courses in Grimsby is £795, per day.
The cost of supplying on-site Excel VBA courses in Burton-upon-Trent is £795, per day.
Our price for supplying on-site Excel VBA courses in Greater London is £795, per day.
The cost of supplying customized Excel VBA courses in Crawley is £795, per day.
The fee for running in-house Excel VBA courses in York is £795, per day.
Our charge for supplying customized Excel VBA training in Leicester is £695, per day.
Our fee for delivering customized Excel VBA training in Southend-on-Sea is £795, per day.
The cost of supplying in-house Excel VBA courses in South Hampshire is £795, per day.
The cost for running customized Excel VBA training in Bedford is £795, per day.
Our fee for delivering Excel VBA courses in Barnsley is £795, per day.
Our price for delivering in-house Excel VBA courses in Blackburn is £795, per day.
Our price for running Excel VBA courses in Gloucester is £795, per day.
Our charge for supplying customized Excel VBA training in Bournemouth is £795, per day.
Our price for supplying customized Excel VBA training in Aberdeen is £895, per day.
The fee for running on-site Excel VBA courses in Peterborough is £695, per day.
Our price for running customized Excel VBA courses in Milton Keynes is £695, per day.
The cost for running customized Excel VBA courses in Kingston upon Hull is £795, per day.
Our price for running Excel VBA courses in Swansea is £795, per day.
Our charge for supplying on-site Excel VBA training in Belfast is £895, per day.