The content has been designed for a one-day classroom course. On course completion, students will be able to:
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.
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 Aberdeen, Edinburgh, Stirling, Dundee, Angus, Fife, Glasgow, London, Perth and most UK locations.
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.
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.
"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
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