Introduction to Visual Basic For Excel

This course is suitable for people who would like to use VBA to enhance their usage of Excel for a more professional result. A thorough understanding of Excel formulas and functions is required. A prior knowledge of Visual Basic is not required.

For advanced users of Excel, coding functionality using Visual Basic (VB) can be used to create extremely powerful and complex spreadsheets. Guided by an expert facilitator, you'll learn how to incorporate VB programming to achieve results outside the scope of Excel's in-built functions.

• Maximise existing Excel functionality by learning how to write programmes

• Automate repetitive, tedious and complex tasks by using advanced ‘If’ statements and macros

• Update VBA programmes by learning how to edit and amend them

• Writing and editing macros

• Assigning macros to a button in the toolbar

• Understanding The Visual Basic Integrated Development Environment and Its Components: Properties Window, Project

• Creating and Editing Modules, Objects and Procedures

• Adding Input and Output Message boxes

• Procedures and Conditions

• Writing Private and Public and Sub-routines

• Creating new functions for use in Excel

• Declaring Constants And Variables

• Variable Types: Dim, Static and Const

• Writing and Understanding Loops & Arrays, Do while and Do Until loops Static and Dynamic Arrays

• Using Advanced "If", "Elseif" and the "Case Selection" alternative

All of our courses are worth 6 hours of CPD per day.