Reset your passwordTo start, please enter your username
Reset your passwordIf an account exists using the username you entered, you will receive an email with a reset code, please use this to reset your password.
Please check your spam folder or call us on 0191 377 8377 if you have trouble finding your reset code.
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.
Overview:
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.
Overview:
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
Overview:
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.
Overview:
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.
You don't seem to have any favourites stored yet.
To add a favourite, please click on the heart next to any course in the course lists or in the right menu on a course page.
Please note if you delete your cookies, your favourites will disappear.
You don't seem to have any favourites stored yet.
To add a favourite, please click on the heart next to any course in the course lists or in the right menu on a course page.
Please note if you delete your cookies, your favourites will disappear.
Our online VBA training courses can be attended from anywhere via Zoom or Micosoft Teams, depending on the course. We can provide a private online VBA course, or you can choose to book on a public scheduled online VBA course. We like to keep our tutor-led virtual online VBA courses small, so we keep delegate numbers low, around 6-8 delegates per online course. If you would like further information on our online courses, please call us on 0191 377 8377, or click here to contact us online.
B.S. Adler and Allan ltd, Microsoft Project Essentials
Following this training what are you going to do differently
"I can work differently and efficiently "
I.M. , Excel Level 3
"Very pleased with the course, trainer ensured we all had understanding before moving on "
T. Westrock, VBA Essentials using Excel
Following this training what are you going to do differently
"Use software more efficiently "
P.M. Teesside Gas and Liquids, Microsoft Project Essentials
"The course was delivered by a lovely tutor who really enjoys what she does. This was evident through out the course which made it a lovely experience for me "
J.E. HMP Full Sutton HMP Gartree, Minute Taking
"All parts relevant with good training materials "
C.L. Direct Rail Services, Excel Level 2
Which part of the course did you find particularly valuable
"How to work out what is good and what does not need to be put into the final draft "
L.T. Direct Rail Services, Minute Taking
"would definitely recommend "
L.H. Hitachi, Excel Level 1
Any other comments or recommendations
"Rob was an excellent teacher and I have found his course extremely helpful, more so than I originally thought it would be. "
C. NHSBSA, Excel Level 3
Following this training what are you going to do differently
"Give time frames to tasks where possible. Use the grid to prioritise "
C.A. Credit Services Association, Time Management
"I now know what I don't know : "
D.S. Watmos, Microsoft Office 365 Overview
"This has been a very useful course. "
S.F. Nissan, VBA Essentials using Excel
What were the most useful aspects of the course
"I already knew a bit about indesign but compound paths and gradients were new to me. "
R.R. EGGER, Adobe InDesign Level 1
Which part of the course did you find particularly valuable
"Learning about the way the connections work with databases with ado etc.. "
M. William Smith, VBA Essentials using Access
"Very happy with what I have learnt. "
J. Lincolnshire Housing Partnership, Excel Level 1
Virtual Training: What is it?
Watch the video:
Welcome to IT Training Solutions!Expert trainers, courses delivered online or in person, small class sizes, flexible content, course materials included and available via your personal training account or in printed form.
Our online VBA training courses can be attended from anywhere via Zoom or Micosoft Teams, depending on the course. We can provide a private online VBA course, or you can choose to book on a public scheduled online VBA course. We like to keep our online VBA courses small, so we keep delegate numbers low, around 6-8 delegates per online course. If you would like further information on our tutor-led virtual online courses, please call us on 0191 377 8377, or click here to contact us online.
Vba Reviews
"Very good course"
B.S. Adler and Allan ltd, Microsoft Project Essentials
Following this training what are you going to do differently
"I can work differently and efficiently"
I.M. , Excel Level 3
"Very pleased with the course, trainer ensured we all had understanding before moving on"
T. Westrock, VBA Essentials using Excel
Following this training what are you going to do differently
"Use software more efficiently "
P.M. Teesside Gas and Liquids, Microsoft Project Essentials
"The course was delivered by a lovely tutor who really enjoys what she does. This was evident through out the course which made it a lovely experience for me"
J.E. HMP Full Sutton HMP Gartree, Minute Taking
"All parts relevant with good training materials"
C.L. Direct Rail Services, Excel Level 2
Which part of the course did you find particularly valuable
"How to work out what is good and what does not need to be put into the final draft"
L.T. Direct Rail Services, Minute Taking
"would definitely recommend"
L.H. Hitachi, Excel Level 1
Any other comments or recommendations
"Rob was an excellent teacher and I have found his course extremely helpful, more so than I originally thought it would be."
C. NHSBSA, Excel Level 3
Following this training what are you going to do differently
"Give time frames to tasks where possible. Use the grid to prioritise"
C.A. Credit Services Association, Time Management
"I now know what I don't know :"
D.S. Watmos, Microsoft Office 365 Overview
"This has been a very useful course."
S.F. Nissan, VBA Essentials using Excel
What were the most useful aspects of the course
"I already knew a bit about indesign but compound paths and gradients were new to me."
R.R. EGGER, Adobe InDesign Level 1
Which part of the course did you find particularly valuable
"Learning about the way the connections work with databases with ado etc.."
M. William Smith, VBA Essentials using Access
"Very happy with what I have learnt."
J. Lincolnshire Housing Partnership, Excel Level 1
Online VBA Course Details
Attend Via Zoom or Microsoft Teams
6-8 Delegates
Course manual included
Private Online Course Options
Public Scheduled Online Training
Virtual online courses available
After course support
Questions encouraged!
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.
Online VBA courses. With virtual VBA training courses, you can attend your VBA course from anywhere. Choose an online VBA virtual course and attend from anywhere. This means you can attend your VBA online virtual training from home, the office, or anywhere else.
In response to the nation-wide need for training amidst a pandemic, you can now attend your Vba training virtually. Virtual Vba training responds to the current need for social distancing whilst being trained efficiently and effectively.
Many people have found that attending an online course virtually has saved them time and money, as travel time and expenses were reduced or eliminated. Whilst virtual Vba courses take place from the comfort of your desk or home, the course has exactly the same content as classroom Vba training. You can call us to discuss your Vba virtual training on 0191 377 8377, we will be happy to help you find the best option for your training.
Contact us online or call 0191 377 8377(Mon-Fri, 9am-5pm)
Over 42 000 delegates have already trained with us
This site requires JavaScript - JavaScript is currently disabled on your device, please be aware that certain functionality may not work until you enable JavaScript.