✖

We understand It can be tricky finding the right training for yourself or for your team. That's why we're here to help you reach your objectives.

You can let us know your unique requirements via our online contact form or you can call us on 0191 377 8377 (Mon-Fri, 9am-5pm) and we will work with you to find the training path that fits your short-term and long-term objectives.

.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

✖

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
- Personal Development
- Live Virtual Online Courses
- 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
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 Course

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.

12 Oct - 14 Oct Attend Online Book

View Course Request Quote

VBA Essentials using Excel Course

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.

12 Jul - 13 Jul Attend Online Book

23 Sep - 24 Sep Attend Online Book

02 Dec - 03 Dec in Leeds Attend Online Book

More Dates

View Course Request Quote

VBA using Word Course

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 Course

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.

15 Jul - 16 Jul Attend Online Book

28 Sep - 29 Sep 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 Course

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.

24 Sep in Durham Attend Online Book

02 Nov in Leeds Attend Online Book

View Course Request Quote

VBA Reviews

Which part of the course did you find particularly valuable "Learned some quick, simple ways that I didn't know were there"

C.P. Egger Uk, Excel Level 2

Any other comments or recommendations "Very good and informative. The trainer was good and not reading from a book, very knowledgeable and approachable. "

S.R. Edinburgh Woollen Mill, Excel Level 2

Following this training what are you going to do differently "I will be able to present and manipulate data at work in a more efficient way. I have learned a lot of new techniques which help to make processes quicker. I will not be scared to see what Excel can actually do and using my booklet I can take my time and keep learning as I grow my confidence in the use of the system."

S.A. Fujifilm Diosynth Biotechnologies, Excel Level 2

Which part of the course did you find particularly valuable "Very easy to follow along with Adele, and very easy to understand. The Data Validation and macros will be very valuable. I thought the excel sheet that we were sent was very well set all."

S.R. , Excel Level 3

Which part of the course did you find particularly valuable "Data validation plus numerous other aspects "

A.T. Hyperdrive Innovation Ltd, Excel Level 3

Following this training what are you going to do differently "Not refer to internet as much for any Excel problems! For what I require in my work I feel more confident with the knowledge Ive gained after today. Also feel I have more knowledge to help my seniors in other Excel based projects. "

R.Y. GSK, Excel Level 3

"Superb course. Possibly the best course I have been on in 22 years in the Fire Service."

J.W. Durham Darlington Fire Rescue, Excel Level 3

Following this training what are you going to do differently "Use Excel more often for valuable shortcuts to tasks that would otherwise take me a long time."

J. , Excel Level 2

What were the most useful aspects of the course "Practical work recommendations that can be applied in the office."

M.S. Great North Air Ambulance Service, Time Management

Any other comments or recommendations "The trainer is very informative and patient "

D.S. Home Office, Excel Level 3

Which part of the course did you find particularly valuable "Learning the correct walkthroughs for processes we do on a regular basis. Knowing the correct terminology to use when speaking to other team members is also great!"

L.O. Cambrex, Adobe InDesign Level 1

What were the most useful aspects of the course "To see that we all had the same issues as no formal training had been done before. These issues can with the help of the course now be sorted."

H.D. Her Majestys Prison and Probation Service, Minute Taking

Which part of the course did you find particularly valuable "The trainer was willing to help until everyone understood"

H.L. Hoults Ltd, Excel Level 1

"Very professional and interesting content that has left me feeling confident in my capabilities"

A.B. Durham, Adobe InDesign Level 1

"Good use of time, well paced delivery"

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

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

VBA training courses are available in , you can call us on 0191 377 8377 to discuss your training options, we will be happy to help you find the right training solutions for you.

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.