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.

