|
VBA-100
VBA FOUNDATIONS
Course Length:
2 Days
Tuition:
$800*Prerequisite*
Highly
competent in all Microsoft Office Applications, especially Access and
Excel.
This
course will teach to to start thinking in terms of how you can make your
work life simpler. This course gets you going in VBA by showing you the
tools to start automating little tasks right away.
Audience:
Programmers who will be developing in VBA 6
What
past students had to say about this class:
Kate was outstanding in ensuring that the information was
understood. Her patience and understanding made it a pleasure. ~J.D. \
USMC
Kate
made the learning experience enjoyable-easy going atmosphere open to
questions & students assisting one another; would definitely taking
another class from Kate. ~C.T. \ GIA
Once
again...well-taught course, can't wait for VBA-200. Thanks ~A.S. \
Callaway Golf
Course Content:
Getting
started with VBA
- What
is VBA?
- What
Products Host VBA?
- What
does a VBA Application look like?
- Working
with VBA in a host product.
- How
do you make VBA code happen?
- Starting
with VBA by recording macros.
Writing
VBA procedures
- Overview
of the Visual Basic Editor.
- Working
with the Project Explorer.
- Creating
simple procedures.
- Understanding
the Code Window.
- Customizing
the Visual Basic Editor.
Working
with VARIABLES and CONSTANTS
- What
is a VARIABLE.
- Data
types.
- Using
CONSTANTS.
Visual
Basic Editor Techniques.
- Writing
code efficiently.
- Taking
advantage of IntelliSense.
- Optional
and Named Arguments.
Mastering
VBA Control Structures
- Branching
Structures.
- Looping
Structures.
Investigating
built-in VBA functions.
- Using
the Object Browser to find VBA functions.
- Testing
functions in the immediate window.
- VBA
functions you'll probably need.
Creating
Reusable Procedures
- Design
before code.
- Writing
the same code once.
Creating
User Forms
- Working
with user forms.
- Adding
controls to a user form.
- Formatting
controls.
- Setting
properties at design time.
- Introducing
events.
- Setting
properties at run time.
- Working
with Methods.
Understanding
Object Models.
- Defining
the terms.
- Using
the object browser.
- Working
with object models in VBA.
- Object
variables.
- Special
VBA control structures for objects.
- Working
with the Office Object Models.
Handling
Errors
- Recognizing
a Run-Time Error
- The
Error-Handling Standard
- Exiting
the Error Handler
- Inline
Error Handling
- Combining
Types of Error Handling
Debugging
your VBA Code
- Debugging
your Code
- Setting
a Breakpoint
- Stepping
through Code
- Checking
Values at Run Time
- Watch
Expressions
- The
Call Stack
- The
Debugging Process
Understanding
Event
- Events
& Event Procedures
- Which
Objects Have Events
- Control
Events
- Product-specific
Events
|
