VBA courses - onsite and offsite

The content has been designed for a one-day classroom course. On course completion, students will be able to:

  1. Use Visual Basic for Applications terminology; start Visual Basic Editor; work with object properties, methods and events; execute code by using a button; and use the Object Browser
  2. Manipulate data by declaring variables and procedures of current scope to be used when and where you need them
  3. Use decision structures to perform decision tasks and loop structures to perform repetitive tasks
  4. Add a user form to your project, add controls to it, handle events associated with form controls, and validate data entry on forms
  5. Identify errors in code, use the debugging tools and write error-handling code to trap errors
  6. This course will help students to become proficient application developers by using the features of Microsoft Excel and Visual Basic for Applications.

click here to see further information about this Excel VBA course

contact us for further information

See our prices 

The content has been designed for a one day classroom course. On course completion, students will be able to:

Use VBA and examine the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures.

Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope.

Work with VBA objects; create, open, save, and close documents by using a Document collection; create a table by using the Tables collection; and work with the Table object.

Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks

This course will give students proficiency in the Visual Basic Editor (VBE), Word objects, basic VBA programming, control structures, debugging tools, advanced VBA programming, and event handling.

click here to see further information about this Word VBA course

contact us for further information

Onsite VBA Courses

ICT Wizard Onsite CoursesVisual Basic for Applications (VBA) training on your premises is highly effective and convenient. Skills are acquired in a familiar environment, courses can be tailored to business needs and staff requirements and trainees can use their own files and equipment for hands-on experience. Only £145 per delegate for a course for four people - and only an additional £75 for each additional delegate. See our prices.

Prices for onsite courses offer superb value, there are no travel or accommodation costs for staff and an expert instructor comes to you at no additional cost to you. We will use your facilities whether it is a fully-equipped training suite or simply a suitable room or office. Our Excel VBA training courses are delivered in AberdeenEdinburghStirlingDundeeAngusFifeGlasgowLondonPerth and most UK locations.

Contact us

Bespoke VBA Courses

In addition to our superb standard training courses we design bespoke courses, develop custom solutions, tailor courses to suit your needs and provide consultancy services at all levels.

Contact us to discuss your requirements for a training course or a support and training programme that meets your staff training needs and business objectives.

Contact us

Fast-track VBA Training

Fast track training sessions are highly-focussed intensive training sessions delivered in short bursts to give busy people the essential skills they need in the shortest possible time.

Our fast-track courses are a quick way to transfer essential skills in the shortest possible time - useful for busy staff members unable to undertake comprehensive training.

Contact us

What Our Clients Say

"The course to say the least was brilliant ... fantastic tutor ... would recommend the company and tutor to anyone" - delegate feedback. We will certainly use you again for future needs."
Group HR Manager, International Vehicle Manufacturer

"Great feedback about the instructor and the high quality of training ... many thanks again for providing us with a truly excellent training experience."
Training Administrator, Aberdeen

"Thanks again for another course run to an excellent standard."
Office Manager, Glasgow

"Please thank the trainer for his hard work last week … so excited after the training … couldn’t wait to start implementing some of the ideas/techniques."
Administration Manager, London

"I enjoyed the course immensely, thanks again."
IT Project and Training Consultant, Oil Company

"Post course support: Thanks! Genius! Thank you so much for not only getting back to me so quickly, but for fixing the problem!"
University Department Head

"The training was fantastic, my colleagues and I really enjoyed the session and we all benefitted greatly."
Project Coordinator Stirling

"Group of Project Managers (all scientists) - MS Project - The training course was excellent."
Vice President, Pharmaceutical Company

enquiries and bookings made simple

Information and advice freely provided ...
... and you will not be pestered by follow-up sales calls!

Contact us for further details about our courses, prices and availability.

An experienced instructor can provide you with advice or assistance without any obligation.

Click here to email us for further information or advice  
Training designed to your requirements
Working with world-class businesses to increase productivity and performance