1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

VBA Programming: A Comprehensive Hands-On Introduction

 
Course: 209   Type: Hands-On Training   Duration: 4 Days
 
 

You Will Learn How To

  • Develop customized solutions using Visual Basic for Applications (VBA)
  • Apply the object models to program effectively in the Microsoft Office System
  • Take full advantage of extensive built-in VBA functionality
  • Exploit ActiveX controls to create functional and familiar user interfaces
  • Troubleshoot code using VBA's debugging tools
  • Secure your code and protect your users from macro viruses

Course Benefits

Effective business solutions do not come straight out of the box. With VBA, you can write code to enhance the off-the-shelf capabilities of Office and other products that support VBA. Using VBA, you can develop custom-built solutions. In this course, you learn the fundamentals of programming and VBA from the ground up. You gain the skills you need to automate repetitive tasks, build user interfaces and increase performance.

Who Should Attend

This course is valuable for anyone who wants to automate tasks through VBA programming. Some experience using the products in the Microsoft Office System is assumed. No previous programming experience is required.

Hands-On Training

Extensive hands-on exercises provide you with practical experience automating Office tasks with VBA programming. Exercises include:
  • Building user interfaces with standard and custom controls
  • Adding powerful subtotaling to an Excel workbook
  • Creating form letters and Outlook mail with customized userforms
  • Protecting users with digital signatures
  • Retrieving Access and SQL Server data for use in Word and Excel
  • Integrating the powerful features of Word and Excel

Related Courses

 
Visual Basic is a registered trademark of Microsoft Corporation. 		 

Upcoming Dates

Feb 3 - 6, 2009
 Washington, DC (Alexandria, VA)
Feb 10 - 13, 2009
 Toronto
Feb 17 - 20, 2009
 New York
Feb 24 - 27, 2009
 Washington, DC (Rockville, MD)
Mar 10 - 13, 2009
 Los Angeles
Mar 31 - Apr 3, 2009
 Chicago (Schaumburg)
Apr 7 - 10, 2009
 Dallas
Apr 21 - 24, 2009
 New York
Apr 28 - May 1, 2009
 Atlanta
May 5 - 8, 2009
 Philadelphia
May 12 - 15, 2009
 Ottawa
May 12 - 15, 2009
 Washington, DC (Alexandria, VA)
May 19 - 22, 2009
 N. New Jersey
Jun 9 - 12, 2009
 Toronto
Jun 16 - 19, 2009
 Washington, DC (Reston, VA)

For complete schedule, please visit www.learningtree.com
 
http://www.learntree.com/courses/209pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

VBA Programming: A Comprehensive Hands-On Introduction

 
Course: 209   Type: Hands-On Training   Duration: 4 Days
 
 
Course 209 Content
 

Introduction

The advantages of VBA

  • An easy-to-use and versatile language
  • Integrated with off-the-shelf products
  • Minimizes development time and costs

Macros: the first step

  • Recording and executing macros
  • Limitations
  • Enhancing with VBA code

Getting to Know the VBA Development Environment

The code design tools

  • Project Explorer
  • Help system
  • Code Window
  • IntelliSense
  • Properties Window
  • Object Browser
  • Block commenting and uncommenting

The debugging tools

  • Code stepping
  • Immediate Window
  • Breakpoints

Writing VBA Code

Event-driven programming

  • The role of events in Windows
  • How events are triggered
  • Responding to events through event procedures

Putting objects to work

  • Properties
  • Methods
  • Events
  • Collections
  • Using With...End With

Storing data in variables

  • How and when to declare variables
  • Selecting data types
  • Fixed and dynamic arrays
  • Constants
  • The scope and lifetime of variables

Conditional branching

  • If...Then...Else
  • Select...Case

Looping through code

  • Do...Loop, While and Until
  • For...Next and For Each...Next

Building procedures

  • Creating Sub and Function procedures
  • Calling procedures
  • Passing arguments to procedures

Empowering VBA through the Application Object Models

Understanding object model structures

  • Exploring the hierarchy using the Object Browser and Help system
  • Referencing specific objects

Writing application-specific procedures

  • Key objects within Excel, Word and Outlook
  • Creating templates and add-ins

Exploiting the power of Automation

  • Controlling one Office application while working in another application
  • Accessing data in databases using ActiveX Data Objects

Building Intuitive User Interfaces

Using intrinsic dialogs

  • Communicating with the user through the message box
  • Gathering user information with the input box
  • Utilizing the FileDialog object and Dialogs collections

Creating customized dialogs with UserForm objects

  • Command buttons
  • List and Combo boxes
  • Option buttons
  • Check boxes
  • Labels
  • Text boxes
  • Frames
  • Adding more functionality with advanced ActiveX controls

Modifying menus and toolbars

  • Simplifying user interaction with the CommandBar object
  • Adding and removing CommandBarControl objects

Providing a Safe and Secure Environment

Handling runtime errors

  • The On Error GoTo structure
  • Classifying errors with the Err object
  • Continuing execution with Resume, Resume Next or Resume label

Implementing security

  • The dangers of macro viruses
  • Macro security levels in Office
  • Applying digital signatures to macros
  • Password protecting your VBA code
 
http://www.learntree.com/courses/209pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

VBA Programming: A Comprehensive Hands-On Introduction Tuition

 
Course: 209   Type: Hands-On Training   Duration: 4 Days
 
 

Course Tuition
$ 2,790 Standard Tuition
Tuition with a Savings Plan
$ 1,800 10-Day Pass
$ 1,670 Training Passport
$ 1,625 Premium-Pass
$ 2,200 Voucher 10-Pack
$ 2,515 Alumni Gold Discount
$ 2,484 Government Discount
 

 

Your Course Tuition Entitles You To...

  • Class participation
  • Team workshops
  • Use of in-class hands-on equipment
  • Comprehensive course materials
  • Morning and afternoon refreshments
  • Course Completion Certificate awarding Continuing Education Units
  • FREE participation in Professional Certification
  • FREE participation in College Credit programs (including related exams)
  
 

Tuition Savings Plans

Training Passport
  • 3 courses in 12 months
  • As little as $1,670 per course
  • Savings as much as 45%
  • Only $5,000
Premium Pass
  • 4 courses in 24 months
  • As little as $1,625 per course
  • Save as much as 45%
10-Day Pass
  • A NEW way to save on training
  • 10 days of training for one person
  • Save as much as $990 per course
  • Only $4,500
Training Vouchers
  • Save as much as $990 per course
  • Fully transferable
  • As low as $2,200 per course
Alumni Gold Discount Attend your first course and you'll receive a personalized Alumni Gold Discount card, entitling you to save as much as $305 on each course you take within the following 12 months. Take just one course each year and you'll be entitled to ongoing discounts...year after year!

Your Guarantee of Satisfaction

Unless you feel 100% satisfied that Learning Tree delivered even more than you expected, there is no fee for your course attendance. Our Guarantee of Quality lets you experience the value of the course--and then pay only if you feel the course was well worth the tuition.

Enrolling is Easy and Flexible!

Enroll by phone or online. If your plans change, just let us know and, without a fee, you can transfer to another course or cancel your enrollment. Pay after you've taken the course, and then only if you are 100% satisfied.
 
http://www.learntree.com/courses/209pf.htm