Explore Contact us

What you will learn

  • This course is designed to give proficiency in the Visual Basic Editor (VBE).
  • Predominantly making use of Excel objects.
  • Basic VBA programming, event handling, control structures, and debugging tools.

Skills you will gain

  • Shareable Certificate Earn a Cerfiticate upon completion
  • On Demand or Face to Face Start instantly and learn at your own schedule
  • Flexible Schedule Set and maintain flexible deadlines
  • Foundation For those starting from the beginning or with a little experience  
  • English Subtitles: English

This course consists of 9 lessons

Getting started: Introducing Visual Basic for Applications - Recording a Macro - Running a Macro - Absolute or Relative Cell Referencing - Saving and Opening Files with Macros - Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, and Buttons - Editing a Macro in the Visual Basic Editor - Understanding the Development Environment - Customising the Editor - Tips for General Typing in VBA - Using Visual Basic Help

Working with Procedures: Program Design - Understanding Modules - Naming Rules - Creating a Module - Understanding Procedures - Programming Macro Concepts - Creating a Subroutine - Creating a Function -Understanding Arguments - Exiting Procedures - Calling Procedures

Understanding Objects, Properties, Methods, and Events: Navigating the Object Hierarchy - Understanding Collections - Accessing a Member of a Collection - Understanding Hierarchy - Using the Object Browser - Using the With Statement - Working with Properties - Working with Methods - Creating an Event Procedure - Reserved Macro Names

Using Expressions, Variables and Intrinsic Functions: Understanding Expressions and Statements - Declaring Variables - Understanding Data Types - Determining the Value of Variables - Working with Variable Scope - Using Built-in VBA Functions - Understanding Constants - Using Message Boxes - Controlling the Answer to a Message Box - Using Input Boxes - Declaring and Using Object Variables

Controlling Program Execution: Understanding Control-of-Flow Structures - Using the If...End If Decision Structures - Nested If Statements - Using the Select Case ... End Select Structure - Using the Do ... Loop Structure

Using the For ... Next Structure - Using the For Each ... Next Structure - Guidelines for Use of Control-of-Flow Structures

Working with Forms and Controls: Understanding UserForms - Creating a Form - Displaying and Removing a Form - Aligning and Sizing Controls - Using the Toolbox - Working with a Form's Properties, Methods, and Events

Working with Form and Control Properties, Methods and Event - Setting the Tab Order - Populating a Control

Debugging and Handling Errors: Understanding Errors - Using Debugging Tools - Setting Breakpoints and Using Break Mode - Stepping Through Code - Trapping Errors with the On Error Statement - Understanding the Err Object - Working with Inline Error Handling - Writing an Error-Handling Routine

Show more

Frequently asked questions

Shareable on LinkedIn

You can share your Course Certificates in the Certifications section of your LinkedIn profile, on printed resumes, CVs, or other documents.

Are you ready to begin learning exceptional new skills?

Call:
01225 308979

Email:
info@go.courses

Find us at:
Go Courses Ltd.
Kemp House
152 - 160 City Road
London
United Kingdom
EC1V 2NX

Registered Office:
Go Courses Ltd.
10 Laura Place
Bath
United Kingdom
BA2 4BL

View on a map

Delighted satisfaction rating