|
|
Overview and objectives
This course will help students to become proficient application developers by
using the features of Microsoft Excel 2003 and Visual Basic for Applications.
Target audience
Students should have familiarity with personal computers and the use of
the keyboard and mouse. They should have completed introduction,
intermediate and advanced courses in Excel 2003 or have equivalent
practical experience
Course objectives
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
Course contents
Getting Started
Introducing Visual Basic for Applications
Recording, running and editing a macro
Understanding the development environment
Understanding objects
Navigating the Excel object
Working with Statements, properties, events and methods
Working
with Procedures and Functions
Understanding and Creating a standard module; sub procedures and
functions procedures
Using
Expressions, Variables and Functions
Understanding expressions and statements
Declaring variables, data types, scope of variables, Constants ,using
spreadsheet functions.
Using message boxes
Using input boxes
Declaring and using object Variables
Controlling Program Execution
Understanding control-of-flow structures
Working with Boolean expressions, Using if, Case; do loop, for next structures
Guidelines for use of control-of-flow structures
Working
with Forms and Controls
Using the toolbox
Working with User Form properties, events and methods, controls and properties
Understanding controls, using Label; text box; Command button; option button;
combo box and
frame controls
Setting the tab order
Populating a control
Adding code to controls
Launching a form in code
Debugging
Code
Understanding errors and debugging tools
Setting breakpoints and stepping through code
determining the value of expressions
Handling
Errors
Understanding error handling and trapping
|
|