IT Training
Visual Basic for Applications
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. |
|
| VB 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 |
| – For..Next |
|
| Day 3 :- |
| VB |
| User Functions |
| Parameters |
|
| Error Handling |
| Interface with User |
| Forms with Dialog Box |
Cost
£750 + VAT for 3-day course
Tailored:
As well as this course being open to any individual (open course) this course can be delivered (closed course): -
to meet individual company requirements
to company housestyles and templates
within company premises
specifically to a group or team of staff
Contact
To book a place or for further information, please contact Suzanne Thomson
t: 01383 559000
f: 01383 559001
e:
suzanne@theblcc.co.uk
IT Booking Page