✖

Before you go! If you're busy, we can manage your training for you, just let us know what you're looking for and we'll do the rest:

.JavaScriptEnabledForm { display: none !important; visibility: hidden !important; } .JavaScriptDisabledForm { display: block !important; visibility: visible !important; }

Name*
Organisation
Telephone
Email*
Address*
Could you give us a clue?
Send me a copy of this email
Send me course updates from time to time
Your subscription will naturally terminate after your chosen time limit.

Your Enquiry

* Required Fields

Name*
Organisation
Telephone
Email*
Address*
Could you give us a clue?
Send me a copy of this email
Send me course updates from time to time
Your subscription will naturally terminate after your chosen time limit.

Your Enquiry

* Required Fields

COVID-19 Alert: You can now attend courses online! We are working hard to respond swiftly to all enquiries, so please give us a call and if all our team members are busy, please leave us a message or drop us an email. We will respond as soon as possible. Thank you.

✖

Sign Up

Create your account

Email*

Password*

Confirm Password*

First Name*

Last Name*

Organisation

I agree to the terms and conditions of using this site
I give permission for my details to be stored

Already have an Account? Sign In

We use cookies to offer you a better experience and to analyse how visitors use our site, for more information please click here . Thank you.

Cookies are small text files that are stored on your computer, phone, tablet or other web enabled device when you visit a website.
We use the following cookies linked to analytics:
_ga, __gat_gtag_UA_845645_1 and _gid

Our cookies do not store private data or data that can identify you personally.

To view full cookie information please click here

Reject

✖

Contact us online or call us on 0191 377 8377

.JavaScriptEnabledForm { display: none !important; visibility: hidden !important; } .JavaScriptDisabledForm { display: block !important; visibility: visible !important; }

Name*
Organisation
Telephone
Email*
Address*
Could you give us a clue?
Send me a copy of this email
Send me course updates from time to time
Your subscription will naturally terminate after your chosen time limit.

Your Enquiry

* Required Fields

Name*
Organisation
Telephone
Email*
Address*
Could you give us a clue?
Send me a copy of this email
Send me course updates from time to time
Your subscription will naturally terminate after your chosen time limit.

Your Enquiry

* Required Fields

≡ Menu

Menu
✕
Sign In
Training and Development
- Course Information
- All Courses
- Microsoft
- Management
- Adobe
- AutoDesk
- Technical IT
- Personal Development
- Public Scheduled Course Dates
- Support and Development
- Remote Hourly Support
- Data Management Solutions
- Help with Microsoft Office
- Support and Development Overview
- Course Details
- Course Types & Bespoke Training
- Training Reviews
- Course FAQs
- After Course
- Evaluate Your Course
- Trainer Login
About
- Contact
- Contact Us
- About Us Info
- Who are we
- Training Venue Details
Careers
- Contact us onlineAny time from anywhereContact Online
- 0191 377 8377Mon - Thur, 9am - 5pm
  Fri 9am - 3:30pm0191 377 8377
✖
Let us know your requirements and we will do the rest
Name*

Organisation

Telephone

Email*

Address*

Could you give us a clue?

Send me a copy of this email

Send me course updates from time to time
Your subscription will naturally terminate after your chosen time limit.

Your Enquiry

* Required Fields

Name*

Organisation

Telephone

Email*

Address*

Could you give us a clue?

Send me a copy of this email

Send me course updates from time to time
Your subscription will naturally terminate after your chosen time limit.

Your Enquiry

* Required Fields

All Microsoft Management Adobe AutoDesk Personal
Development Technical IT Sage Entrepreneurship Graphic
Design Web
Development Environment
Health and Safety

VBA Training Courses

Skip to: Courses Reviews About Your Course Why Us?

VBA Essentials using Access

This course can be attended online or at a training venue

£750_+VAT?

Price per delegate on a public scheduled course. Private courses are also available, please request a quote for prices. All prices +VAT.

This course is aimed at those who would like to develop their skills and knowledge of VBA programming in Access application development.

31 May - 02 Jun Attend Online Book

12 Oct - 14 Oct in Durham Attend Online Book

View Course Request Quote

VBA Essentials using Excel

This course can be attended online or at a training venue

£495_+VAT?

Price per delegate on a public scheduled course. Private courses are also available, please request a quote for prices. All prices +VAT.

This course is aimed at those people who find they have reached their limit with the menu items of Excel and need to modify Excel to be better suited to their environment, by creating their own functions and procedures.

15 Apr - 16 Apr Attend Online Book

12 Jul - 13 Jul Attend Online Book

23 Sep - 24 Sep in Durham Attend Online Book

02 Dec - 03 Dec in Leeds Attend Online Book

More Dates

View Course Request Quote

VBA using Word

This course is designed to help experienced Word users automate common tasks and create end user systems. The user does not have to be a programmer to benefit from this course but any programming experience will be of value

View Course Request Quote

Access Advanced Database Design

This course can be attended online or at a training venue

£445_+VAT?

Price per delegate on a public scheduled course. Private courses are also available, please request a quote for prices. All prices +VAT.

This Microsoft Access course is for delegates who have sound skills in the use of MS Access and are now ready to expand their knowledge into some of the more specialised and advanced features of the software. This course will provide delegates with the skills needed to create complex queries, create macros to automate tasks, enhance forms and reports and use the Access programming language Visual Basic for Applications (VBA), enabling delegates to really take control of their databases.

02 Feb - 03 Feb Attend Online Book

19 Apr - 20 Apr Attend Online Book

08 Jun - 09 Jun Attend Online Book

15 Jul - 16 Jul Attend Online Book

09 Sep - 10 Sep in Leeds Attend Online Book

28 Sep - 29 Sep in Newcastle Attend Online Book

16 Nov - 17 Nov in Leeds Attend Online Book

08 Dec - 09 Dec in Durham Attend Online Book

More Dates

View Course Request Quote

Excel Advanced Macros

This course can be attended online or at a training venue

£295_+VAT?

Price per delegate on a public scheduled course. Private courses are also available, please request a quote for prices. All prices +VAT.

This course is designed to introduce you to the Macro environment of Excel, it will provide you with the confidence to record macros in Excel and then be able to gain a better understanding of the code and make changes to it.

We even teach you some commands that cannot be recorded, such as how to show a message to the person who runs the macro.

It will not turn you into a fully-fledged programmer, but you will feel more confident in the Visual Basic Editor, and thus be able to explore more aspects of programming in Excel.

For example, if you record a macro before the course and you make a mistake in the recording, you invariably have to start the recording again. After this course you will be able to step through the code, decide what you wish to keep and what you wish to get rid of, then record an extra part and add it to the code you kept thus running all the code at once.

Important Note : An Excel Macro is created from lines of code of Visual Basic for Applications. These lines of code are stored in a collection called a 'Macro' or a 'Procedure'. It all depends on which angle you are coming from. If you're a programmer, you call these lines of code a Procedure; if you are an advanced user of Excel you call these lines of code a Macro.

19 Jan Attend Online Book

29 Mar Attend Online Book

04 Jun Attend Online Book

24 Sep in Durham Attend Online Book

02 Nov in Leeds Attend Online Book

More Dates

View Course Request Quote

VBA Reviews

Following this training what are you going to do differently "Now feel confident to try out DAX in calculations and to make alterations to layouts, etc."

A.R. Durham County Council, Microsoft Power BI Desktop

"Confidence has grown and I'm raring to go. I came confused and left armed with information and knowledge"

K.J. Direct Rail Services, Minute Taking

Which part of the course did you find particularly valuable "It was all new skills for me, so I found the whole course valuable."

D.W. Deepocean, Microsoft Project Essentials

Following this training what are you going to do differently "Use Excel in different and easier ways"

P.C. CMR UK Ltd, Excel Level 2

What were the most useful aspects of the course "Learning different skills when speaking to people "

M.S. FPE Seals Ltd, Introduction to Supervisory Management

"Very enjoyable. The style and content was on point"

T.B. Van Leeuwen, Negotiating and Influencing Skills How to Influence and Negotiate Assertively

Following this training what are you going to do differently "Learned how to do speedier shortcuts"

J.R. Sealy UK, Excel Level 2

"All aspects of the course were valuable"

J.C. William Smith, VBA Essentials using Access

Which part of the course did you find particularly valuable "I particularly found it helpful how hands on it was and being able to play around on the programme ourselves"

H.J. Innovation SuperNetwork, Adobe InDesign Level 1

"[The trainer] was very patient, and very helpful"

L.F. Durham County Council, Microsoft Power BI Desktop

Following this training what are you going to do differently "Tidy up the current spreadsheets that I use using the new features that I have learnt. Will help me with my KPIs."

C.G. Vehicle Lease and Service Ltd, Excel Level 2

"Good use of time, well paced delivery"

C.F. Stockton on Tees Borough Council, Microsoft Project Essentials

"Would recommend to others in performance reporting posts"

L.F. Durham County Council, Microsoft Power BI Desktop

"The tutor was excellent, patient and clear"

S.D. Ground Control, Excel Level 3

Which part of the course did you find particularly valuable "Slicers in pivots and table pivots. Macros , Data validation. Sum IF/Count IF "

M.P. Tharsus, Excel Level 3

What to expect on your course

Expert trainers
Lunch provided*
Course manual included
Drinks and snacks provided*
Small course sizes
1 delegate per laptop
After course support
Wear what you feel comfortable in*
Pens and paper provided
Questions encouraged!
*May differ when training is held at the client’s site.

Why IT Training Solutions?

25
Over 25 years training experience
42
Over 42 thousand already trained
200
Over 200 courses
100
100% expert trainers
Established in 1992, IT Training Solutions Ltd began life as an on-site computer training company in response to the business worlds growing demand for flexible, high-quality training at an affordable price. Today, IT Training Solutions Ltd has grown in size and is one of the leading training providers in the North East, providing training courses on a large number of IT and personal development subjects.

More information on VBA

We provide VBA courses , our VBA Courses can be available as scheduled or private courses, meaning that you can benefit from training that fits your exact requirements. If you are unsure which VBA Courses would suit you, or if you would like help deciding, please give us a call on 0191 377 8377 or contact us online, we will be happy to help.

Private Courses

Private Courses the ultimate in flexible training. You choose the timescale, you choose the location, you choose the delegate(s) and you choose the content.

Public Scheduled Courses

Scheduled Courses easy to book - we set the date, location and outline, so all you need to do is let us know which course you would like to attend.

If a public scheduled course is not available for VBA , we can provide private, or onsite, courses for you in your location. One way or another, contact us to let us know how we can help or to book your courses.

✖

Name*
Organisation
Telephone
Email*
Address*
Could you give us a clue?
Send me a copy of this email
Send me course updates from time to time
Your subscription will naturally terminate after your chosen time limit.

Online Classroom Choose later

I would like to book the course:

for

delegates.
Location:

Your notes to us:

Enter Delegate Names

* Required Fields

✖

Name*
Organisation
Telephone
Email*
Address*
Could you give us a clue?
Send me a copy of this email
Send me course updates from time to time
Your subscription will naturally terminate after your chosen time limit.

Online Classroom Choose later

Please send me a quote for

for

delegates.
Location:

Your notes to us:

* Required Fields

You can choose from over 200 courses
Your course will be delivered by an expert
Over 42 000 delegates have already trained with us

Tutor-led Virtual Online Courses

Attend Courses From Anywhere

Live online training

See Online Courses

Click here to contact us online

Contact us any time or call 0191 377 8377 (Mon-Fri, 9am-5pm)

.JavaScriptEnabledForm { display: none !important; visibility: hidden !important; } .JavaScriptDisabledForm { display: block !important; visibility: visible !important; }

Name*
Organisation
Telephone
Email*
Address*
Could you give us a clue?
Send me a copy of this email
Send me course updates from time to time
Your subscription will naturally terminate after your chosen time limit.

Your Enquiry

* Required Fields

Name*
Organisation
Telephone
Email*
Address*
Could you give us a clue?
Send me a copy of this email
Send me course updates from time to time
Your subscription will naturally terminate after your chosen time limit.

Your Enquiry

* Required Fields

This site requires JavaScript - JavaScript is currently disabled on your device, please be aware that certain functionality may not work until you enable JavaScript.