Telephone: 01382 453447
email: mail@ictwizard.com

ICT Wizard

 

Excel VBA Programming

1-day course

Course Aims

This content has been designed for a one day classroom course. On course completion, students will be able to:

  • Use Visual Basic for Applications terminology; start Visual Basic Editor; work with object properties, methods and events; execute code by using a button; and use the Object Browser
  • Manipulate data by declaring variables and procedures of current scope to be used when and where you need them
  • Use decision structures to perform decision tasks and loop structures to perform repetitive tasks
  • Add a user form to your project, add controls to it, handle events associated with form controls, and validate data entry on forms
  • Identify errors in code, use the debugging tools and write error-handling code to trap errors

This course will help students to become proficient application developers by using the features of Microsoft Excel and Visual Basic for Applications.

For further details, or to book a course, please contact us:
email:        training@ictwizard.com
telephone:  01382 453447
 

Our VBA courses include:

Excel VBA

Word VBA

Access VBA
 

ICT Wizard courses:

on your site or locations throughout the UK

Computer training courses in Aberdeen, Dundee, Glasgow, Edinburgh and London

delivered by Certified Master Instructors.