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 2003 and Visual Basic for Applications.
Students should have familiarity with personal computers and the use of the keyboard and mouse. They should have completed Level 1, 2 & 3 courses in Excel 2003 or have equivalent practical experience.
Visual Basic for Applications Object programming The Object Browser
Working with data Scope of variables Scope of procedures
Using decision structures Using loop structures
User forms Handling events
Errors in code Using debugging techniques Error-handling
(c) Melton IT Services Ltd 2001-2006 Last Updated 13/08/2006
[Legal
Policy] | [
Privacy Policy]