This course is provided by Wintrac. Wintrac
provides one stop shopping for all your IT training needs. Wintrac’s course
catalog of over two thousand courses includes courses on Visual Basic
Training
Visual Basic Training Overview
VBA for Microsoft Office courseware will teach you to start thinking in terms of how you can make your work life simpler. This courseware gets you going in VBA by showing you the tools to start automating little tasks right away.
Visual Basic Training Prerequisites
Familiarity with Microsoft Office.
Visual Basic Training Audience
Programmers who will be developing in VBA6.
Visual Basic Training Course duration
3 Days
Visual Basic Training Course outline
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
VBA's Built-In 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
Additional ActiveX Controls
Working with Methods
Working with List Boxes and Combo Boxes
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 Events
Events and Event Procedures
Which Objects Have Events?
User Form Events
Control Events
Product-Specific Events
Is There More?
Putting It All Together
Assembling the Pieces
Building a Solution in Excel
Using the Solution in Word
Where Are You Going From Here?
Appendix A: Calling VBA Procedures From the User Interface
Appendix B: Comparison of VBA, Visual Basic, and Microsoft Access Forms
Appendix C: The Reddick VBA Naming Conventions
Appendix D: Creating Reusable Procedures
Appendix E: Techniques with List Boxes and Combo Boxes
Please contact your training representative for more details on having this course delivered onsite or online
