Visual Basic For Applications

Aims

Microsoft Excel is a powerful tool for the office. Recording and using Macros helps to automate many of the common tasks you do with your spreadsheet. However, you may want to take it a step further.

This course helps you to:

Record useful macros.

Understand the language that macros use (VBA).

Extend the functionality of the macros by writing your own macros using extensions to the language, for example, loops and decisions.

Understanding and using VBA will increase your efficiency and the power of your software.

Day 1
Macros	What are they? Beginning and end? Where are they stored? Examine a few statements
Editor	Available Windows Step Through? Watch
Objects	What are they? Properties. Methods. Explore possibilities and information.
Day 2
VB – Variables	Input from the user (InputBox) Output to the user (Msgbox)
VB – Control Language	Selection - if..then..endif Iteration - Do Until..loop Iteration - For..Next
Day 3
VB	User Functions Parameters
Error Handling
Interface with User
Forms with Dialog Box

Cost: £750 excl. VAT

Course Dates & Booking

Print Factsheet

Make an Enquiry

News and Events
Find Out More ››

Current Promotions
Find Out More ››