Visual Basic For Applications

Course Dates & Booking Print Factsheet Make an Enquiry

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

Carnegie Enterprise
Carnegie Conference Centre
Halbeath Road, Dunfermline, Fife, KY11 8DY
Tel: 0844 248 0141 | Fax: 0844 248 0120

"PRINCE2® is a Registered Trade Mark of the Office of Government Commerce in the United Kingdom and other countries". "The Swirl logo™ is a Trade Mark of the Office of Government Commerce. MSP™ is a Trade Mark of the Office of Government Commerce. The Swirl logo™ is a Trade Mark of the Office of Government Commerce. M_o_R® is a Registered Trade Mark of the Office of Government Commerce in the United Kingdom and other countries. The Swirl logo™ is a Trade Mark of the Office of Government Commerce. P3O® is a Registered Trade Mark of the Office of Government Commerce The Swirl logo™ is a Trade Mark of the Office of Government Commerce.

Callback request