Skip to content
Home » Excel VBA & Macro Training in East Sussex | At Your Business Premises

Excel VBA & Macro Training in East Sussex | At Your Business Premises

    Established in 2005, Blue Pecan delivers Excel VBA & Macro training at customers’ business premises in East Sussex. Our two day Excel VBA & Macro training course gives delegates a good introduction to recorded macros and VBA programming. The course is designed for advanced Excel users who need to develop automated solutions.

    We deliver Excel VBA & Macro training to businesses in East Sussex including Brighton and Hove, Eastbourne, Hastings, Bexhill-on-Sea, Seaford, Crowborough, Hailsham, Portslade-by-Sea, Peacehaven, Lewes, Uckfield & Newhaven.

    Our courses are compatible with any version of Excel including Excel 365, 2019, 2016, 2013, 2010 and 2007.

    On-Site and Online Training Prices

    These prices are for in-house private training courses, scheduled for businesses or individuals.  Training can be provided onsite at your workplace or online via Zoom or MS Teams.

    Half-day session: 09:30 to 12:30 or 13:00 to 16:00 or to suit. Full-day session: 09:30 to 16:00 or to suit

    No. of delegatesOn-site full dayOnline full day
    1 - 10£695£650
    Additional delegates+£25+£25

    *Two half-days are priced as one full day.

    All prices are excluding VAT. 

    On-site training travel expenses included for Sussex, Surrey, Hampshire, Berkshire, Buckinghamshire, Kent, Oxfordshire, London and most Essex, Dorset, Wiltshire, Somerset and Hertfordshire locations.  Please enquire.

    Our 2 day Microsoft Excel Macros and Visual Basic for Applications (VBA) course is aimed at those who need gain a good grounding in this programming language.

    Download the course outline in pdf format.

    Recording Macros

    • Recording a Macro
    • Recording a Macro Using Relative References
    • Useful Navigation and Selection Shortcut Keys to Use When Recording Macros
    • Recording Techniques For Macros That Need to Work Regardless of the Number of Columns or Rows
    • Editing a Recorded Macro in the VBA Editor

    Running and Storing Macros

    • Saving Macro Enabled Excel files
    • Where to Store Macros
    • Macro Security
    • Customising the Quick Access Toolbar and Ribbon with Macro Buttons
    • Adding Form Buttons to a Sheet

    Intro to VBA

    • What is VBA?
    • Understanding Parts of Speech: Objects, Collections, Methods, Parameters and Properties
    • Application Methods and Properties
    • Window/s Methods and Properties
    • Workbook/s Methods and Properties
    • Worksheet/s Methods and Properties
    • Range Methods and Properties
    • Chart/s Methods and Properties

    Working With Ranges

    • Referencing Cells/Ranges
    • CurrentRegion
    • The End Property
    • Offset
    • Resize
    • Intersect
    • UsedRange
    • SpecialCells
    • Areas
    • Rows and Columns
    • Copy/Move
    • Formatting Cells and Values

    Working With Worksheets

    • Activate Worksheet
    • Create New Worksheet
    • Delete a Worksheet
    • Name a Worksheet
    • Copy/Move Worksheet
    • Group Worksheets
    • Hide Worksheets
    • Protect Worksheets

    Working With Workbooks

    • Open/Close Workbook
    • Save Workbook
    • Delete Workbook
    • Protect Workbook
    • Add Named Reference Within a Workbook

    Working With Charts

    • Create an Embedded Chart
    • Delete a Chart
    • Create a Chart On a Chart Sheet
    • Apply Chart Style
    • Colour a Chart
    • Position and Size a Chart
    • Add Titles and Other Chart Elements

    Variables & Constants

    • Naming Variables
    • Declaring a Variable’s Data Type
    • Option Explicit
    • Scoping Variables
      • Local
      • Module-wide
      • Public
    • Static Variables
    • Life of a Variable
    • Assigning Values to Variables and Object Variables
    • Constants

    Programming Flow

    • If Then Else, ElseIf
    • Select Case

    Creating Loops

    • For Each Next – Looping Through Workbooks, Worksheets & Ranges
    • For Next Loops
    • Do Loops – Do Until, Do While, Exit Do

    Events

    • Workbook Events
    • Worksheet Events
    • OnKey Events

    Interactivity

    • MsgBox
    • InputBox
    • Application.InputBox
    • Designing Userforms

    Function

    • Worksheet Functions
    • VBA Functions
    • User Defined Functions

    Debugging and Error Handling

    • Types of Errors
      • Syntax Errors
      • Compile Errors
      • Run-time Errors
    • Stepping Through Code
    • Setting Breakpoints
    • Using the Immediate Window
    • Setting Watches and Using the Watch Window
    • Using the Locals Window
    • Error Trapping and Handling
      • On Error Resume Next
      • On Error Goto
      • Specifying Error Handling for Different Run-time Error Numbers