• Exeter, Devon EX2 7AE
  • hello@amesolutions.co.uk
  • Office Hours: Monday - Friday 8:30 AM – 5:00 PM
Thumb
Microsoft Excel Training Course

Microsoft Excel VBA Programming Overview

This page gives you a full overview of our Excel VBA Programming Course, what’s included, the key topics we cover, and what you can expect to learn as someone with confience using commands.

    Microsoft Excel VBA Programming Training Overview

    DURATION

    2 full days: 9:30am – 4:30pm

    LOCATION

    Exeter, Devon, Cornwall, Somerset, Dorset, Onsite at your premise, Remote Live Session via Teams

    For onsite courses we can provide the rental of laptops with the software pre-installed.

    OVERVIEW AND OBJECTIVES

    This 2-day course has been specially designed for the advanced user who wants to make use of the more powerful features of Excel made available by VBA. This course explores VBA language and delegates will be encouraged to write programs to ensure that future editing, amending and updating can be carried out with the minimum of effort.

    TARGET AUDIENCE

    Existing Excel power users who wish to utilize the VBA to develop more sophisticated applications.

    WHATS INCLUDED

    🔹Professional instructor‑led training

    🔹Courseware included

    🔹Lunch provided

    🔹Free on‑site parking at our Exeter training suite

    🔹Certificate of completion

     

    COURSE PREREQUISITES

    Excel users who are confident in their use of the commands, functions and simple Macros gained by prior attendance on an “Excel Advanced” course or via user experience.

    WHY CHOOSE OUR EXCEL TRAINING?

    With years of experience delivering Excel courses to businesses and individuals, we make learning Excel simple, practical, and enjoyable. The VBA course provides the ideal foundation for building your skills for work, study, and personal use.

    SUBJECT AREAS

    • What is a Macro?
    • Recording a Macro
    • Running a Macro
    • Relative References
    • Assigning a Macro to a Button on a Worksheet
    • Assigning a Macro to a Button on a Toolbar
    • Button Image Editor
    • The Visual Basic Editor
    • The Project Explorer
    • The Code Window
    • Procedures
    • Inserting Comments
    • Printing a Visual Basic Module
    • What is the Range Object?
    • The Cells Property
    • The Range Property
    • Flexible Ranges
    • Range Contents
    • Activating a Workbook
    • Activating a Worksheet
    • ThisWorkBook
    • Controlling Objects with their Properties
    • Performing Actions with Methods
    • Performing Multiple Actions on an Object
    • Control Structures
    • Conditional Control Structures
    • Looping Control Structures
    • Non-Structured Statements
    • Sub procedures
    • Built-In Dialogue Boxes
    • Predefined Dialogue Boxes
    • Custom Forms
    • Worksheet Forms
    • Setting the Properties of a Control
    • User-Defined Forms
    • Adding Form Controls
    • Form Control Properties
    • Control and Dialogue Box Events
    • Displaying and Dismissing a User Form
    • Handling Form Controls
    • The Windows Registry
    • Settings Files
    • About Toolbars and Menus
    • Attaching Toolbars to
    • Workbooks
    • Saving More Than
    • One Toolbar Configuration
    • Customising Toolbars
    • Display
    • Techniques
    • What are Errors?
    • Types of Error
    • Break Mode
    • Instant Watch
    • Stepping Through Code
    • Error Handling
    • Function Procedures
    • User-Defined Functions
    • Function Wizard
    • Excel Functions
    • What is an Add-in?
    • Creating an Add-In
    • Converting an Add-In to a Workbook
    • Conventions
    • User Form Controls
    • Memory Variables
    Have Questions or Ready to Book?

    For more information, or to book onto our Microsoft Excel VBA training course, please get in touch.

    If there’s a Microsoft course you’re interested in that isn’t listed on our website, let us know we can arrange one‑to‑one onsite training with our trainer.

    You can view our full list of training courses here.

    Office Location

    2nd Floor Wear House, Topsham Road,
    Exeter, Devon. EX2 7AE.

    Phone

    01392 824022

    Email

    info@amesolutions.co.uk

    Name