0800 019 6882

 
 
 
Home |Course Schedule |Onsite training | FAQ | Book |Offers |Contact |Reputation |Guarantee
 

Excel 2003 - Macros and Introduction to VBA (1 day course)

This one day Excel VBA course can be booked according to our course schedule, or alternatively you can book a trainer to visit you.  Contact us for more details!

Please note we can tailor this VBA course to suit your needs, for example we can include Access VBA, Word VBA etc.  We can hold this course onsite at your premises or we can source a suitable meeting room.

Course objectives:

By the end of this course you should be confident to create procedures for controlling the behaviour and appearance of an Excel spreadsheet, create procedures that run in response to specific events, create user forms to accept or display data, validate the data entry in user forms, and debug and handle errors in code.

Prerequisites:

You should be an advanced user of Excel and ideally have attended Intermediate and Advanced level courses before this course.

Course contents

VBA terminology

  • Start the VBA editor

  • Work with:

    - Object properties

    - Methods

  • Attach code to events and buttons

  • Use the object browser

Programming basics

  • Variables and data types

  • Expressions

  • Manipulating data

  • Getting input from the user in Input and Message boxes

  • Variables and scope

  • Procedures

  • Calling one procedure from another

Using loops

  • Do / while

  • For / Next

  • If...Else..End..If

  • Select Case...Case 1,2,3, Else...End Else

USER FORMS

  • Creating a dialog box (user form)

  • Displaying a dialog box

  • Using text boxes and labels

  • Using command buttons

  • Using combo and list boxes

  Error handling

  • Identifying compile-time, run-time and logical errors in code

  • Use the debugging tools

  • Write error handling code to trap errors

If you would like to make an enquiry about our Training, fill in the form below, or call us on 0800 019 6882, or email us at sales@computertrainingsolutions.co.uk


First Name
Surname
Company Name
Phone
Email
City
Main Course Area of Interest
Query
Image Verification
Please enter the text from the image
[ Refresh Image ] [ What's This? ]

 

 


Register for our newsletter to receive details of current special offers!

 

 
Home |Course Schedule |Onsite training | FAQ | Book |Offers |Contact |Reputation |Guarantee

Tel:0800 019 6882 Ts and Cs Privacy Policy

Web: www.computertrainingsolutions.co.uk

We accept card payments via Nochex

JB Consulting Ltd trading as Computer Training Solutions

 

Applications

Excel courses

Powerpoint Training

Word training

Microsoft Access training Courses

Visio training

MS Project training

Dreamweaver training

 

Join us on Facebook!

 Computer Training Solutions

Additional links

IT Training in Bristol

IT Training in Birmingham

IT Training in Reading

Training in Birmingham

Excel Courses in London

View sitemap

Clicky Web Analytics