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.
"Explained and demonstrated in a simple way not patronising. Tailored to our job role. Absolutely brilliant course so useful, thank you. "
B.R. Dogs Trust, PowerPoint Essentials
"Excellent course well presented. "
N.C. Cembre Ltd, Excel Level 1 Essentials
Which part of the course did you find particularly valuable
"Understanding the capabilities and structures of a project "
M.H. Teesside Gas and Liquids, Microsoft Project Essentials
What were the most useful aspects of the course
"Learning different skills when speaking to people "
M.S. FPE Seals Ltd, Introduction to Supervisory Management
"Very Informative and relevant "
J.C. Lincolnshire Housing Partnership, Document Storage in Microsoft Office 365
"I enjoyed it. "
J.C. Lincolnshire Housing Partnership, Document Storage in Microsoft Office 365
"I found the whole course very interesting and informative. I will take a completely different approach to meetings in the future. "
S. HMP Isle of Wight, Minute Taking
"Brill, as always, [the trainer] is lovely! Welcoming, friendly, helpful "
V.K. , Outlook Working more Efficiently
"Another great course from IT Training Solutions! "
A.R. NIHR Clinical Research Network North East and Nort, Adobe Photoshop Level 1
Following this training what are you going to do differently
"Increase technical ability and streamline my work. Use more of the functions rather than typing out formulas. "
D.S. Home Office, Excel Level 2
"Very satisfied with this training, would recommend it! The presenter was very professional and friendly! "
A. , Excel Level 2
"Set topics covered but also individual objectives discussed and actioned. Material in booklet useful to takeaway. "
A.A. Hill Cross Furniture, Introduction to Supervisory Management
Are there any aspects of the course which you feel require improvement
"None, enjoyed every aspect "
C.G. Vehicle Lease and Service Ltd, Excel Level 2
"Really enjoyed the training, Thank you "
L.G. James Jones and Sons Ltd, Excel Level 1 Essentials
Following this training what are you going to do differently
"Create better charts, make use of Tables, and make use of the IF Function and Conditional Formatting. I will also now be able to work better with dates, and generate data on timescales between processes. "
D.S. South Tyneside Homes, Excel Level 2
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
"Explained and demonstrated in a simple way not patronising. Tailored to our job role. Absolutely brilliant course so useful, thank you."
B.R. Dogs Trust, PowerPoint Essentials
"Excellent course well presented."
N.C. Cembre Ltd, Excel Level 1 Essentials
Which part of the course did you find particularly valuable
"Understanding the capabilities and structures of a project "
M.H. Teesside Gas and Liquids, Microsoft Project Essentials
What were the most useful aspects of the course
"Learning different skills when speaking to people "
M.S. FPE Seals Ltd, Introduction to Supervisory Management
"Very Informative and relevant"
J.C. Lincolnshire Housing Partnership, Document Storage in Microsoft Office 365
"I enjoyed it."
J.C. Lincolnshire Housing Partnership, Document Storage in Microsoft Office 365
"I found the whole course very interesting and informative. I will take a completely different approach to meetings in the future."
S. HMP Isle of Wight, Minute Taking
"Brill, as always, [the trainer] is lovely! Welcoming, friendly, helpful"
V.K. , Outlook Working more Efficiently
"Another great course from IT Training Solutions!"
A.R. NIHR Clinical Research Network North East and Nort, Adobe Photoshop Level 1
Following this training what are you going to do differently
"Increase technical ability and streamline my work. Use more of the functions rather than typing out formulas. "
D.S. Home Office, Excel Level 2
"Very satisfied with this training, would recommend it! The presenter was very professional and friendly!"
A. , Excel Level 2
"Set topics covered but also individual objectives discussed and actioned. Material in booklet useful to takeaway."
A.A. Hill Cross Furniture, Introduction to Supervisory Management
Are there any aspects of the course which you feel require improvement
"None, enjoyed every aspect"
C.G. Vehicle Lease and Service Ltd, Excel Level 2
"Really enjoyed the training, Thank you"
L.G. James Jones and Sons Ltd, Excel Level 1 Essentials
Following this training what are you going to do differently
"Create better charts, make use of Tables, and make use of the IF Function and Conditional Formatting. I will also now be able to work better with dates, and generate data on timescales between processes."
D.S. South Tyneside Homes, Excel Level 2
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.