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.
Public scheduled prices per delegate. All prices +VAT
<
>
Private Courses:
Private courses start from £745 for up to 8 delegates
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.
No results found on this page, searching our other courses
Ask us a question:
Online VBA Course
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.
"I felt the course was really excellent and no improvement needed "
S.D. Everyturn, Excel Level 3
What were the most useful aspects of the course
"I felt learning about the pathfinder tool and default options the most useful aspect for me. This will save me a lot of time! "
H.Y. CMP Products British Engines, Adobe InDesign Level 1
Which part of the course did you find particularly valuable
"The whole course was great, really helpful. Nothing was too much to ask Moira. "
H.S. Department for International Trade, Adobe In Design Level 1
"Good course and [the trainer] was great Thank you "
A.B. UMi Commercial Ltd, Google Analytics Essentials GA4
What other courses would you like to attend
"Stuart was very helpful and has a very good way of getting the point accross "
J.F. Encore Envelopes, Access Essentials An Introduction to Database Design
"[The trainer] was fantastic, an absolute credit to the company. Very well presented and engaging throughout very knowledgeable. "
L.R. Public scheduled course, Excel Level 3
"Very enjoyable course "
W.M. Gestamp UK Ltd, Excel Level 1 Essentials
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
"I found all aspects of this course valuable. I am looking forward to adding formulas to my spreadsheets and creating graphs for reporting purposes. "
L.M. , Excel Level 2
Any other comments or recommendations
"The course has been very valuable and informative the trainer was great and went above course information to help me understand information about the software ie helped with links to my sage accounts "
B.E. Nordem Ltd, Sage Payroll
Which part of the course did you find particularly valuable
"Chat, upload and share documents "
D.A. Engie Services Ltd, Microsoft Teams in Office 365 Essentials
"Learned a lot that I should be able to use in my day to day work. Training was very easy to follow trainer was very helpful with any queries. "
P.S. Komatsu, Adobe Illustrator Level 1
Which part of the course did you find particularly valuable
"The macro and pivot functions "
S.B. GSK, Excel Level 3
Any other comments or recommendations
"I have obtained so much from this course, would recommend to anyone "
A.M. PX Group, Word Advanced Features
"Really enjoyed the course and felt I learnt more that I expected "
K.W. James Jones and Sons, Excel Level 1 Essentials
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
"I felt the course was really excellent and no improvement needed"
S.D. Everyturn, Excel Level 3
What were the most useful aspects of the course
"I felt learning about the pathfinder tool and default options the most useful aspect for me. This will save me a lot of time!"
H.Y. CMP Products British Engines, Adobe InDesign Level 1
Which part of the course did you find particularly valuable
"The whole course was great, really helpful. Nothing was too much to ask Moira."
H.S. Department for International Trade, Adobe In Design Level 1
"Good course and [the trainer] was great Thank you"
A.B. UMi Commercial Ltd, Google Analytics Essentials GA4
What other courses would you like to attend
"Stuart was very helpful and has a very good way of getting the point accross"
J.F. Encore Envelopes, Access Essentials An Introduction to Database Design
"[The trainer] was fantastic, an absolute credit to the company. Very well presented and engaging throughout very knowledgeable."
L.R. Public scheduled course, Excel Level 3
"Very enjoyable course"
W.M. Gestamp UK Ltd, Excel Level 1 Essentials
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
"I found all aspects of this course valuable. I am looking forward to adding formulas to my spreadsheets and creating graphs for reporting purposes."
L.M. , Excel Level 2
Any other comments or recommendations
"The course has been very valuable and informative the trainer was great and went above course information to help me understand information about the software ie helped with links to my sage accounts"
B.E. Nordem Ltd, Sage Payroll
Which part of the course did you find particularly valuable
"Chat, upload and share documents"
D.A. Engie Services Ltd, Microsoft Teams in Office 365 Essentials
"Learned a lot that I should be able to use in my day to day work. Training was very easy to follow trainer was very helpful with any queries."
P.S. Komatsu, Adobe Illustrator Level 1
Which part of the course did you find particularly valuable
"The macro and pivot functions"
S.B. GSK, Excel Level 3
Any other comments or recommendations
"I have obtained so much from this course, would recommend to anyone "
A.M. PX Group, Word Advanced Features
"Really enjoyed the course and felt I learnt more that I expected"
K.W. James Jones and Sons, Excel Level 1 Essentials
Online VBA Course Details
Attend Via Zoom or Microsoft Teams
6-8 Delegates
Course materials included
Private Virtual Course Options
Public Scheduled Online Training
Virtual online courses available
Questions encouraged!
Why IT Training Solutions?
Friendly,
knowledgeable
trainers
Adaptable, flexible training solutions: we work along with you to find training which fits your requirements
Small class sizes
Choice of
training locations
100% trainer led
Over 30 years experience training
Your Course Portal
Access your course materials online via your own personal training account*.
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)
This site requires JavaScript - JavaScript is currently disabled on your device, please be aware that certain functionality may not work until you enable JavaScript.