Type to search LearningTree.com

Do you mean "{{response.correctedQuery}}" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.

 

Microsoft Office Training









Preferred method of contact?

VBA Programming Introduction

COURSE TYPE

Practitioner

Course Number

209

Duration

4 Days

Enroll

About This Course: VBA can enable your organization to create custom and effective business solutions. In this course, you will learn the fundamentals of VBA programming from the ground up. You will gain the skills needed to automate repetitive tasks, build user interfaces and increase performance. Using VBA, you can write code and develop custom-built solutions.

You Will Learn How To

  • Develop custom solutions, automate tasks and increase performance
  • Apply the object models to program effectively in the Office System
  • Enhancing the Office 2007-2013 Ribbon with new functionality
  • Exploit ActiveX controls to create functional and familiar UIs
  • Troubleshoot code using debugging tools
  • Secure your code and protect your users from macro viruses

Course Outline

  • Introduction

The advantages of VBA

  • An easy-to-use and versatile language
  • Integrated with off-the-shelf products

Macros: the first step

  • Recording and executing macros
  • Limitations
  • Enhancing with VBA code
  • Getting to Know the VBA Environment

The code design tools

  • Project Explorer
  • Help system
  • Code Window
  • IntelliSense
  • Properties Window
  • Object Browser

The debugging tools

  • Code stepping
  • Immediate Window
  • Breakpoints
  • Writing VBA Code

Event-driven programming

  • The role of events in Windows
  • 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

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 with the Object Browser and Help
  • 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
  • Labels
  • Option buttons
  • Check boxes
  • 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
  • Executing 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
Show complete outline
Show Less

Course Schedule

Attend this live, instructor-led course In-Class or Online via AnyWare.

Hassle-Free Enrollment: No advance payment required.
Tuition due 30 days after your course.

Oct 4 - 7 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Dec 19 - 22 Herndon, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jan 10 - 13 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Feb 7 - 10 Rockville, MD/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Feb 14 - 17 Alexandria, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Feb 28 - Mar 3 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Mar 14 - 17 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

May 30 - Jun 2 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jun 6 - 9 Herndon, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jul 4 - 7 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Aug 15 - 18 Alexandria, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Aug 22 - 25 Rockville, MD/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Guaranteed to Run

Show all dates
Show fewer dates

Bring this Course to Your Organization and Train Your Entire Team
For more information, call 1-888-843-8733 or click here

Tuition

Standard

$2990

Government

$2659

Course Tuition Includes:

After-Course Instructor Coaching
When you return to work, you are entitled to schedule a free coaching session with your instructor for help and guidance as you apply your new skills.

Free Course Exam
You can take your course exam on the last day of your course and receive a Certificate of Achievement with the designation "Awarded with Distinction."

Prev
Next

Questions

Call 1-888-843-8733 or click here »

An experienced training advisor will happily answer any questions you may have and alert you to any tuition savings to
which you or your organization may be entitled.

Training Hours

Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm


FREE Online Course Exam (if applicable) – Last Day: 3:30 pm – 4:30 pm
By successfully completing your FREE online course exam, you will:

  • Have a record of your growth and learning results.
  • Bring proof of your progress back to your organization
  • Earn credits toward industry certifications (if applicable)
  • Make progress toward one or more Learning Tree Specialist & Expert Certifications (if applicable)

Enhance Your Credentials with Professional Certification

Learning Tree's comprehensive training and exam preparation guarantees that you will gain the knowledge and confidence to achieve professional certification and advance your career.

This course qualifies for 23 CPE credits from the National Association of State Boards of Accountancy CPE program. Read more ...

“I really appreciated the way we online students were able to participate in the VBA programming class via AnyWare. It did not feel at all like we were thousands of miles away!”

- Y. Freeman, Director of Marketing Operations
Macy’s Inc. Software

Prev
Next