VBA For Excel Training

This VBA for Excel training course is designed to give a good working knowledge of Visual Basic for Applications – concentrating on Microsoft Excel.

VBA for Excel Training

Many advanced Excel users know how to use Macros to automate tasks by recording them using the Macro recorder, and running them at a later date.

However more advanced automation - particularly tasks that link spreadsheets and other office applications together - require VBA.

During this VBA for Excel Course students will learn to create and edit macros, and gain an understanding of VBA code.

The Visual Basic for Applications content of the training course can be applied to other Microsoft Applications.

We also provide private and in-company VBA for Excel courses. Call +44 (0)1273 622272 to discuss.

Video: Introduction to VBA for Excel

This video provides a useful introduction to what Excel VBA is and how to access the Developer toolbar:

VBA for Excel Training

Prerequisites

Before attending out VBA for Excel Training course you must have attended our Advanced Excel Course or have equivalent experience.


Course Objectives

Upon completion of this course, delegates will know how to:

  • Create and edit Macros.
  • Use and understand VBA code.
  • Link and combine spreadsheets and other Office applications.
  • Set up advanced automation features.

 

Who is this course for?

This course is ideal for those who already possess and advanced level of experience with Excel (ideally after attending our Advanced Excel Course) and are looking to expand their knowledge further into other areas of the software's capability.

Creating Record Macros

  • Recording & running Macros
  • Macros Dialog Box
  • Editing a Macro with Visual Basic

Visual Basic Editor

  • Objects, Methods, Properties
  • Programming Tools
  • The Menu Bar

Running Code

  • Run mode and Design mode
  • Running Code from the development environment & the host application

The Project Explorer

  • Using the Project Explorer

The Properties Window

  • Changing a Property

Using Constants

  • Excel & Variable Constants

Excel Objects

  • Objects, Properties and Methods
  • Getting & Setting Properties
  • Calling Methods
  • Passing Arguments
  • Singular Objects & Collections of Objects

Variables

  • Dimensioning a variable
  • Using variables in routines
  • Object Variables

Using Visual Basic Functions

  • InputBox Function
  • MsgBox Function
  • Using a Set Statement

Building Formula Control Structures

  • If…Then Decision Structures
  • Logical Operators
  • Select Case Decision Structures
  • Case Else
  • Comparison Operators with Select Case Structure
  • For… Loops & Do Loops
  • While...Wend Statement

UserForms

  • Designing & Creating Forms
  • Working with Controls
  • Creating Custom Dialog Boxes
  • Userform Properties Methods & Events

Event Handling

  • VBA Editing & Debugging
  • Auto Macros
  • Error Handling

Taught me a lot of new things and provided good revision on other areas. The course focused on practical applications such as designing forms, as well as giving some theoretical background.

David Stone - Esure Ltd

A good introduction to basics followed by the introduction of more complex functions. Very good coverage of a very complex subject.

David Palmer - ISP Microcaps UK Ltd

Good working through the pre-coding stages, e.g drawing the problem out on paper and following it through logically.

Stuart Taylor - Brighton & Hove City Council

Good pace, covering relevant content to us. Good mix of demonstrated examples & tasks to work through individually. Trainer always on hand to answer questions and very approachable

Matthew Schofield - Esure Ltd

Filled in lots of holes in my knowledge. Particularly liked the usage of forms, learning the syntax for referring to controls within the form.

Jack Ringshall - Esure Ltd

The tutor was very passionate about VBA and was able to fund solutions to all our problems, if he didn't know he investigated alongside us.

Sarah Drane - Esure Ltd

Keypoints

keypoints accredited

Starting Price:£1095

Duration:1 Day

VBA For Excel Training Calendar

Filters

Select Your Course

Select Your Location

Select Delivery Method

Keypoints

keypoints accredited

Starting Price:£1095

Duration:1 Day

VBA For Excel Training

Best Selling Course in UNITED KINGDOM

flag

Southampton, UNITED KINGDOM

duration

Duration : 1 Day

dates

15 Nov 2024

£3495

VBA For Excel Training

Best Selling Course in UNITED KINGDOM

flag

London, UNITED KINGDOM

duration

Duration : 1 Day

dates

6 Dec 2024

£3495

VBA For Excel Training

Best Selling Course in UNITED KINGDOM

flag

Manchester, UNITED KINGDOM

duration

Duration : 1 Day

dates

13 Dec 2024

£3495

VBA For Excel Training

Best Selling Course in UNITED KINGDOM

flag

Birmingham, UNITED KINGDOM

duration

Duration : 1 Day

dates

27 Dec 2024

£3495

VBA For Excel Training

Best Selling Course in UNITED KINGDOM

flag

Aberdeen, UNITED KINGDOM

duration

Duration : 1 Day

dates

22 Nov 2024

£3495

VBA For Excel Training

Best Selling Course in UNITED KINGDOM

flag

Milton Keynes, UNITED KINGDOM

duration

Duration : 1 Day

dates

29 Nov 2024

£3495

VBA For Excel Training

Best Selling Course in UNITED KINGDOM

flag

Virtual, UNITED KINGDOM

duration

Duration : 1 Day

dates

16 Dec 2024

£995

VBA For Excel Training

Complete the steps below to receive a quote or more information

Enter Your Details

What is your name?*
user
Course Name
course

How Many Employees Need Training?

Enter More Details

call
company
address
message

When Would You Like to Take the Course?

Add Additional Features

6 Months Access - £219
1 Year Access - £439

Your Online (VBA For Excel Training ) Package

Upon purchase you will receive a password via the email you used to purchase the course.

You will then be able to login to our online learning platform with your email and password.

You will have access to the platform for 90 days to complete your course.

Enroll Now for Our Online Course

£1095

enquire Enquire Now
meeting

Upcoming Dates

Onsite Training

Our Onsite/In-house Training method is most selected by organisations, as it allows them to train their employees at their choice of place. We can also tailor the course content to focus on your needs.

Leading Path to Success

step-1

Find a course and let us know how you would like to learn.

Step 1

step-2

Select your preferred method of training for the course.

Step 2

step-3

Confirm your seats.

Step 3

step-4

Get an excellent experience with our qualified instructors.

Step 4

step-5

Acquire skills and achieve your career goals.

Step 5

460+

Courses

92+

Locations

126K+

Learners

Some Facts Worth Shouting About

To win in this competitive world, you need to be constantly moving forward, and Silicon Beach Training is the one that can help you. Our courses are highly engaging as we have high-quality and certified training courses for both individuals and organisations that are structured in easy to digest modules. We don't compromise on the quality of our trainers. We have:

Our Clients

With extensive experience working with large organisations, national and local government, universities, charities, SMBs and individuals we believe that no client is too big or too small. This creates a diverse atmosphere on our scheduled courses with the opportunity to discuss solutions for a wide range of problems. We excel at developing bespoke training solutions for prestigious clients including EDF Energy, Sport England and Tesco PLC.

Banco Central Do Brasil

Nationwide Building Society

EDF Energy

EDF Energy

Sport England

Sport England

Tesco PLC

Tesco PLC

Imperial College London

Imperial College London

Request info Get Free Advice Quick Enquiry
LOADING