| Print |

Excel VBA

Location Cambridge
Price ex. VAT 485 GBP
Start Date 27 February 2019
Course type Standard
Course code FROG230
Duration 2 Day

Description

Delegates will gain a general knowledge of VBA to manipulate and improve processes using Microsoft Excel.

Target Audience

Designed for advanced users of Excel.

Prerequisites

Delegates should be experienced advanced level users of Microsoft Excel or have attended the Advanced Formulae and Functions and Validate and Summarise courses.  This is a very fast paced course and a knowledge of recording macros is required.

Outline

What is Visual Basic for Applications?

    An Introduction to Macros

    • Recording Macros
    • Running Macros

    Understanding the Visual Basic Environment

    • The Visual Basic Editor
    • Understanding the syntax of your Macros
    • Editing Macros
    • Adding comments and documentation to your macros
    • Assigning VBA and Macros to keyboard shortcuts, icons and menus

    With Statements

      Managing Error Messages

        Debugging Techniques

        Working with Variables and Data Types

          User Defined Functions

            Understand Objects and Collections

              Add conditions to your macros

                Communicate with the user

                • Message boxes
                • Input Boxes
                • Working with return values

                Repeating Actions in VBA – Loops

                • Fixed loops
                • Flexible Loops

                Customise Menus and Toolbars

                  Automation with Macros

                  • Create Custom Dialog Boxes

                  Book the course: Excel VBA

                  Course Search