✖

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

31 May - 02 Jun Attend Online Book

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

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

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

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

"A very good course, thanks."

S.F. Nissan, VBA Essentials using Excel

"Very good trainer. Highlighted some great features of InDesign"

J.P. EGGER, Adobe InDesign Level 1

Which part of the course did you find particularly valuable "Teaching and learning cycle"

E.O. Thermo Fisher Scientific, Train the Trainer

"Looking forward to trying some of the things I've learned"

M.L. Healthwatch North Tyneside, Excel Level 2

Which part of the course did you find particularly valuable "Pivots and shortcuts and security "

A.T. Sealy UK, Excel Level 3

"Looking forward to putting what I've learnt into practice!"

C.G. Northumbria University, Microsoft Power BI Desktop

Following this training what are you going to do differently "Now that I know formulas, I won't have to watch how to videos on Youtube, I can just refer back to my training notes."

S.P. Drummond Central, Excel Level 2

"Really useful course thank you!"

L.O. Labour Party, Excel Level 3

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

D.S. Home Office, Excel Level 3

"Great facilities and trainer"

C. The Auckland Castle Trust, Photoshop Level 1

"Excellent session, thank you"

C.M. , Excel Level 2

Which part of the course did you find particularly valuable "Tips about emails urgent and importance division. "

S.M. Contec Inc, Time Management

"Excellent, thorough, thought provoking, interesting"

T.B. Alnwick Medical Group, Coaching and Mentoring

"I thought the course was really helpful and I would fully recommend."

E.F. Egger, Excel Level 2

Which part of the course did you find particularly valuable "All of it, but mostly use of formula and tables"

S.H. GSK, 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

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.