Microsoft Excel VBA Training – Level 2 (2 days)

    Our Excel VBA Level 2 course is designed for experienced Excel users who have already begun to create macros and know their way around Excel’s Visual Basic Editor. This course delves deeper into the Excel object model and provides delegates with practical experience of developing their own VBA solutions.

    Excel object model

    About classes and objects, Objects and collections, The hierarchy of objects, Properties, methods and events, The Locals Window, The Immediate Window

    Function procedures

    Sub versus function, User-defined functions, Declaring a function, Calling a function, Private and public scope, Defining arguments, Optional arguments

    The Application object

    When to use, ScreenUpdating property, DisplayAlerts property, Setting CutCopyMode to false

    Dialogue boxes

    MsgBox function, InputBox function, Application.Dialogs

    UserForms

    Creating a userform, Displaying a userform, Adding Label controls, Adding a TextBox control, The CheckBox control, The OptionBox control, ComboBox and ListBox, SpinButton controls, Adding CommandButtons, Setting control properties

    Workbooks and worksheets

    The Workbooks collection, The Sheets collections, The Window objects, Workbook events

    Ranges and names

    Column and Row properties, CurrentRegion property, The Union method, The Intersect method, Using the Name property, Working with named ranges

    Pivot tables

    Pivot table code overview, Creating a pivot table, PivotField object, PivotItems collection, Modifying a pivot table, Using external data

    Charts and drawings

    About programming charts, Working with embedded charts, Working with independent charts, Controlling chart formatting, Assigning a range to a chart, Positioning a chart, Making a chart active/inactive, Editing data series, Controlling chart labels, Drawing shapes, Setting shape attributes


    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.