✖

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
The effects of COVID-19 are being felt across the UK. Unfortunately, during this difficult time we will be unable to take incoming calls. Therefore, please leave us a message and we will get back to you as soon as possible. Our online contact forms have not been affected but response times will be longer. We would like to take this opportunity to thank you for your patience and support during this period. Stay safe. From the team here at IT Training Solutions.

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

View privacy policy

✖

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
✕
Training and Development
- Course Information
- Courses A-Z
- Public Scheduled Course Dates
- Course Types & Bespoke Training
- Training Reviews
- Course FAQs
- Development Information
- System and Database Development
- 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

VBA Training Courses

Skip to: Courses Reviews About Your Course Why Us?

VBA Essentials using Access

£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.

01 Jun - 03 Jun in Durham 13 Oct - 15 Oct in Durham

View Course Request Quote

VBA Essentials using Excel

£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.

16 Apr - 17 Apr in Leeds 29 Apr - 30 Apr in Durham 11 Jun - 12 Jun in Durham 11 Jun - 12 Jun in Leeds 17 Sep - 18 Sep in Leeds 24 Sep - 25 Sep in Durham 03 Dec - 04 Dec in Leeds

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

£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.

20 Apr - 21 Apr in Durham 09 Jun - 10 Jun in Leeds 16 Jul - 17 Jul in Durham 10 Sep - 11 Sep in Leeds 29 Sep - 30 Sep in Newcastle 17 Nov - 18 Nov in Leeds 09 Dec - 10 Dec in Durham

More Dates

View Course Request Quote

Excel Advanced Macros

£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.

05 Jun in Leeds 25 Sep in Durham 03 Nov in Leeds

More Dates

View Course Request Quote

VBA Reviews

"Everything was useful"

N.R. Northern Powergrid, Excel Level 2

Which part of the course did you find particularly valuable "Structuring my training in a way my trainees will get the best training from myself "

A.W. Thermo Fisher Scientific, Train the Trainer

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

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

"A very good course, thanks."

S.F. Nissan, VBA Essentials using Excel

"It gave me insight into how to give constructive feedback and not be scared to give it to strangers"

R.H. Welwyn Components Ltd, Train the Trainer

"I'm very pleased I went on this course I have learnt a lot and I'm sure I will be more efficient in my role as a result. The tips I learnt will save me a lot of time at work."

D.S. Joseph Rowntree Foundation, Outlook Essentials

"Excellent, very enjoyable. Well Presented"

G.T. Houghton International, Word Essentials

Following this training what are you going to do differently "Use shortcuts more effectively "

W.O. S Sheard Son Limited, Excel Level 3

Following this training what are you going to do differently "It will speed up my work with spreadsheets "

A.R. S Sheard Son Limited, Excel Level 3

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

"Pivot Tables I'm going to have fun with this when I return to work!"

K.T. PX Group, Excel Level 3

"The course has shown me the easier way to do things I was doing before so I will put that into practice."

L.P. Egger UK, Excel Level 2

Which part of the course did you find particularly valuable "Understanding my personal objectives and challenges and talking through them with examples of goals to improve"

C.R. Froneri International plc, Assertiveness Skills

Following this training what are you going to do differently "This will speed up and improve appearance of charts which I produce in reports "

P.B. Egger UK, Excel Level 2

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 in

We provide VBA courses in , 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 in , 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.

I would like to book the course:

for

delegates in

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.

Please send me a quote for

for

delegates in

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

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.