Excel 2007 VBA Programming
Overview:
Learn the skills necessary to use Visual Basic for Applications (VBA) code to create and extend the functionality for complex macros and to automate difficult or time consuming tasks in Excel. Also learn about procedures, IF-Then-Else statements, making the code repeat steps (loop), creating user forms and debugging code.
Pre-requisite(s):
Ability to use Absolute & Relative references, Autofill, Named Ranges, record a Macro, customize the toolbar
Audience:
Students looking to gain the skills necessary to extend macros beyond what can be achieved by recording a macro and creating custom user forms.
Length/Cost:
1 Day, $295
Outline:
|
Lesson 1 : Visual Basic Editor
|
|
Visual Basic for Applications
Object programming
The Object Browser
|
|
Lesson 2 : Programming basics
|
|
Data basics
Scope of variables
Scope of procedures
|
|
Lesson 3 : Control structures
|
|
Decision structures
Loop structures
|
|
Lesson 4 : Custom dialog boxes
|
|
User forms
Events
|
|
Lesson 5 : Debugging and error handling
|
|
Errors
Debugging
Error handling
|
Schedule:
 = "Guaranteed to Run" |
|
ILT - Instructor-Led Training | MLT - Mentor-Led Training | OC - Online Classroom Learning |
| Location | | Register | Time |
|
Bellevue (ILT)
|
|
Oct 26
| 8:00AM-4:00PM |
|