Log On/Register  

855.838.5028

Introduction to VBA Programming

Duration: 3 Days
Course Price: $1,295

Course Overview:

Students will learn design considerations and deployment scenarios related to building customer solutions using Microsoft Office 2003. Using the methodologies presented, students will be able to build solutions that access data and automate business processes, using Microsoft Office 2003. In addition, the content of this course is directed at assisting the student to prepare for the Microsoft Exam 70–091.


Performance-Based Objectives

  • Reviewing Macros
  • Understanding when to use VBA
  • Become familiar with the Visual Basic Editor
  • Setting properties for a project
  • Editing recorded Macros
  • Creating code from scratch
  • Understanding syntax
  • Using Procedures and Functions
  • Working Variables and Constants
  • Using Arrays
  • Finding Object, Methods, and Properties you need
  • Using Loops and Functions
  • Create your own Functions
  • Using IF statements
  • Creating Message Boxes
  • Creating and using Dialog Boxes
  • Building Modular Code
  • Debugging Code
  • Working with Office Programs and code
  • Accessing one application from another application

Visit the Learn IT! Programming & Scripting Portal for more information on this track.

Course Overview:

Students will learn design considerations and deployment scenarios related to building customer solutions using Microsoft Office 2003. Using the methodologies presented, students will be able to build solutions that access data and automate business processes, using Microsoft Office 2003. In addition, the content of this course is directed at assisting the student to prepare for the Microsoft Exam 70–091.


Performance-Based Objectives

  • Reviewing Macros
  • Understanding when to use VBA
  • Become familiar with the Visual Basic Editor
  • Setting properties for a project
  • Editing recorded Macros
  • Creating code from scratch
  • Understanding syntax
  • Using Procedures and Functions
  • Working Variables and Constants
  • Using Arrays
  • Finding Object, Methods, and Properties you need
  • Using Loops and Functions
  • Create your own Functions
  • Using IF statements
  • Creating Message Boxes
  • Creating and using Dialog Boxes
  • Building Modular Code
  • Debugging Code
  • Working with Office Programs and code
  • Accessing one application from another application

Visit the Learn IT! Programming & Scripting Portal for more information on this track.

Prerequisites:

To ensure your success, we recommend you first take the following Learn iT! courses or have equivalent knowledge:

  • Knowledge of the basic features of the Microsoft Word, Excel, PowerPoint, and Access applications
  • Able to record simple macros by using Macro Recorder and invoke them
  • Possess ability to perform the following functions using Visual Basic: write a function procedure and a sub procedure; handle an event procedure; retrieve and validate information from a user; build a user interface with forms and controls; describe the relationship between objects, properties, and methods; add run-time error handling to an application; and run an application, using the debug mode in the Visual Basic environment
  • Define a database table
  • Define a database query
  • Create database queries using SQL syntax
  • Define the terms Internet, intranet, and Web browsing
  • Possess a basic understanding of Microsoft Visual Basic and Office product functionality, or having successfully completed an Access 2000 programming or Visual Basic 6.0 programming course

Course Content

GETTING STARTED WITH VBA

Recording Your First Macro
What Is a Macro?
Recording a VBA Macro


Writing Your Own MacrosDisplaying the Visual Basic Editor
Touring the Visual Basic Editor
Writing Your Own Command Macro
Running a VBA Macro
Creating User-Defined Functions with VBA
Working with Procedures
Working with Modules
Shutting Down the Visual Basic Editor


Understanding Program VariablesDeclaring Variables
Avoiding Variable Errors
Variable Data Types
Using Array Variables
Working with Constants.


Building VBA ExpressionsWorking with VBA Operators
Understanding Operator Precedence
Working with Numeric Expressions
Working with String Expressions
Working with Logical Expressions
Working with Date Expressions


Working with ObjectsThe Object Hierarchy
Working with Object Properties
Working with Object Methods
Handling Object Events
Working with Object Collections
Assigning an Object to a Variable
The Is Operator
Working with Multiple Properties or Methods


Controlling Your VBA CodeCode That Makes Decisions
Using If...Then to Make True/False Decisions
Using If...Then...Else to Handle a False Result
Making Multiple Decisions
Functions That Make Decisions
Code That Loops
Using Do...Loop Structures
Using For...Next Loops
Using For Each...Next Loops
Using Exit For or Exit Do to Exit a Loop

PUTTING VBA TO WORK


Programming WordWorking with Documents
Working with Text
The Range Object
The Selection Object
The Characters Object
The Words Object
The Sentences Object
The Paragraph Object.


Programming ExcelExcels Application Object
Manipulating Workbook Objects
Dealing with Worksheet Objects
Working with Range Objects.


Programming PowerPointPowerPoints Application Object
PowerPoints Presentation Object
Working with PowerPoint Slide Objects
Dealing with Shape Objects
Operating a Slide Show


Programming Access DatabasesGetting Ready: Two Steps Before You Begin
Working with Database Records: Opening a Recordset
Working with a Recordset. Retrieving Data into Excel


Programming Outlook EmailWorking with Outlook Folders
Working with Email Messages
Sending a Message
Working with Attachments
Programming Outlook from Other Applications

GETTING THE MOST OUT OF VBA


Interacting with the UserProgramming Sounds. Displaying Information to the User
Getting Input from the User


Creating Custom VBA Dialog BoxesAdding a Form to Your Project
Changing the Forms Design-Time Properties
Working with Controls
Handling Form Events
Types of Form Controls
Using a Form in a Procedure


Creating Custom Menus and ToolbarsAssigning Macros to Menu Commands
Creating Custom Toolbars for Your Macros
Menus, Toolbars, and VBA
Understanding Command Bars
Working with Command Bar Controls


Debugging VBA ProceduresTrapping Program Errors
A Basic Strategy for Debugging
Pausing a Procedure
Stepping Through a Procedure
Monitoring Procedure Values
Using the Immediate Window
Debugging Tips

Updated 9.17.08

Learn More
Please type the letters below so we know you are not a robot (upper or lower case):