✖

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

Sign in to my account

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

Tutor-led Virtual Training Click here to see how it works

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 21 - 02 Jun 21 in Durham Attend Online Book

12 Oct 21 - 14 Oct 21 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.

03 Dec - 04 Dec in Leeds Attend Online Book

15 Apr 21 - 16 Apr 21 in Leeds Attend Online Book

18 May 21 - 19 May 21 in Durham Attend Online Book

10 Jun 21 - 11 Jun 21 in Leeds Attend Online Book

12 Jul 21 - 13 Jul 21 in Durham Attend Online Book

16 Sep 21 - 17 Sep 21 in Leeds Attend Online Book

23 Sep 21 - 24 Sep 21 in Durham Attend Online Book

02 Dec 21 - 03 Dec 21 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.

17 Nov - 18 Nov Attend Online Book

09 Dec - 10 Dec in Durham Attend Online Book

02 Feb 21 - 03 Feb 21 in Durham Attend Online Book

19 Apr 21 - 20 Apr 21 in Durham Attend Online Book

08 Jun 21 - 09 Jun 21 in Leeds Attend Online Book

15 Jul 21 - 16 Jul 21 in Durham Attend Online Book

09 Sep 21 - 10 Sep 21 in Leeds Attend Online Book

28 Sep 21 - 29 Sep 21 in Newcastle Attend Online Book

16 Nov 21 - 17 Nov 21 in Leeds Attend Online Book

08 Dec 21 - 09 Dec 21 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.

03 Nov in Durham Attend Online Book

19 Jan in Leeds Attend Online Book

27 May in Durham Attend Online Book

04 Jun in Leeds 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

"All of it is going to be really useful."

L.O. Labour Party, Excel Level 2

"I feel more clear in mind of my objectives going forward and how to achieve them"

S.R. J2 Research, Time Management

"Would recommend to anybody interested"

J.D. Spicers, Train the Trainer

"Excellent course and trainer"

L.J. PX Group, Word Advanced Featuresbr

"Our tutor was fantastic really knowledgeable and enthusiastic"

K.J. Direct Rail Services, Minute Taking

Which part of the course did you find particularly valuable "The tips given throughout the session are really useful"

M.R. XPS Pensions Group, Train the Trainer

"[The trainer] was very patient with us and was always interested in how we have done things in the past and gave a very honest opinion and honest feedback. Thank you very much."

P. , Computers for Beginners and Getting Started with MS Office

"Excellent training, excellent facilities"

A. , Computers for Beginners and Getting Started with MS Office

"Brilliant from start to finish."

E.D. Wave, Adobe InDesign Level 1

"I felt all of the course was useful"

T. Westrock, VBA Essentials using Excel

"Trainer was very knowledgeable"

D.M. CMR UK Ltd, Excel Analysing and Presenting Data with Dashboards and Pivot Tables

"Good trainer and very clued up on subject"

H.G. Vantec, Excel Analysing and Presenting Data with Dashboards and Pivot Tables

Are there any aspects of the course which you feel require improvement "None, I feel greatly informed and had opportunity to discuss and ask what I wanted"

S.R. J2 Research, Time Management

"The course offers everything it says it does."

C.R. , Business Writing Skills

Which part of the course did you find particularly valuable "All of it each topic gave great insight and I learnt things I didn't know before "

L.K. XPS Pensions Group, Train the Trainer

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.