Excel 2003 VBA

ExecuTrain of Indianapolis
Indianapolis, Indiana, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Excel 2002/2003: VBA Programming
1 Day

Outline

Visual Basic Editor
Visual Basic for Applications
Discussing VBA
Examining the VBE window
Object Programming
Examining the Properties window
Changing the object properties
Using code to change object properties
Using a method
Associating VBA code with an event
Executing VBA code by using a button
The Object Browser
Examining the Object Browser
Searching in the Object Browser
Programming basics Data
Discussing data types and variables
Discussing and declaring variables
Using operators
Using the interaction functions
Scope of variables
Understanding procedure and module-level scope
Understanding public scope
Scope of procedures
Creating a Sub procedure
Calling a Sub procedure
Creating a Function procedure
Calling a Function procedure
Control structures
Decision structures
Using the If…Then statement
Using the If…Then…Else statement
Using the If…Then…ElseIf statement
Using the Select Case statement

Loop Structures
Using the For…Next loop
Using the For Each…Next loop
Using the Do While…Loop
Custom dialog boxes
User forms
Adding a user form
Adding controls to a user form
Events
Attaching an event handler to a control
Validating data by using event handlers
Debugging and error-handling
Errors
Discussing types of errors
Debugging
Discussing debugging tools
Setting a breakpoint
Adding a watch expression
Using Step Into
Deleting a watch expression
Working with the Immediate window
Working with the Locals window
Error-handling
Using the On Error GoTo statement
Using the On Error Resume Next statement
...''

Phone:(317) 574-7057

School Address:

8900 Keystone Crsg Indianapolis, IN 46240 USA

Jobs & Resumes: Indianapolis
Houses & Roommates: Indianapolis

Photoshop CS2 Advanced
ACT 2006
Publisher 2003
Acrobat 8
PageMaker 7.0
Coldfusion MX
HTML
Lotus Notes 7.0
Quickbooks 2006
Outlook 2003
Powerpoint 2003
PowerPoint 2007
Excel 2007
Word 2007
Acrobat 7
Project 2007 Advanced
Visio 2003
Access 2007
Frontpage 2003

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Besides Acquiring latest course information by the search form, Students can also leave their study interests here and let schools callback.