Microsoft Excel VBA Training

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

  [Legal Policy]  | [ Privacy Policy]  [Top]  [Links]  [Pricing]