Word: VBA Programming Training

Word: VBA Programming Training (WRD401)

Course Length: 1 day
Delivery Methods: Available as private class only
Course Overview

This VBA programming for Word training course is designed to give experienced Word users proficiency in using the Visual Basic Editor (VBE). Students will learn how to build applications, debug code, automate data entry, and merge data files. They will also learn how to create forms, build tables, secure information, and share data.

Our public classes use the most current version of the software, but if you’re on an earlier version, our instructor will point out any differences. For private classes, we will use the version of the software you use in your office.

Course Benefits
  • Master the Visual Basic for Applications (VBA) environment in Microsoft Word to automate repetitive tasks and streamline your document processing workflows.
  • Learn object programming fundamentals to manipulate Word objects efficiently, enhancing your ability to create dynamic document content.
  • Gain expertise in writing and debugging event procedures and macros, which can significantly improve the interactivity and functionality of Word documents.
  • Become proficient in utilizing the help system within the VBA editor to troubleshoot and enhance your programming scripts.
  • Understand how to effectively manage data within VBA, including variable scope and naming conventions, to ensure clear, maintainable code.
  • Develop skills in creating custom user input forms using VBA, which can collect data directly within Word documents and use it to automate document formatting and content creation.
  • Learn to implement control structures in VBA, such as decision-making processes and iterative operations, to make logical determinations about how and when certain actions should be performed in your documents.
  • Create sophisticated custom dialog boxes that adhere to Windows standards, enhancing user interaction with your VBA scripts through professional and intuitive interfaces.
  • Acquire advanced debugging and error handling techniques to create robust VBA applications in Word that are reliable and user-friendly.
  • Explore automation techniques and error trapping within Word to enhance document security, prevent data loss, and ensure your macros run smoothly across multiple instances.
Microsoft Certified Partner

Webucator is a Microsoft Certified Partner for Learning Solutions (CPLS). Our curriculum has been tested and approved by ProCert Labs, the official tester of Microsoft courseware, and has been found to meet the highest industry standards of instructional quality.

Microsoft Silver Certified Partner
Course Outline
  1. Visual Basic Editor
    1. Visual Basic for Applications
    2. Object Programming
    3. Event Procedures and Macros
      1. Event Procedures
      2. Macros
    4. Using Help
      1. Getting Help in the Object Browser
    5. Using the Visual Basic Editor in Word
      1. The DisplayDate Procedure
  2. Programming Basics
    1. Data Basics
    2. Scope of Variables
      1. Reserving a Procedure-level Variable
    3. Naming Variables
      1. Selecting the Appropriate Data Type and Name for a Variable
    4. Using Variables to Accept User Input
      1. Reserving a Procedure-level String Variable
      2. The InputBox Function
      3. Concatenating Strings
    5. Using String Variables in Word
      1. Creating a Fax Transmittal Sheet
      2. Creating the FaxTransmittal Macro Procedure
      3. Creating a Custom Button
  3. Control Structures
    1. Decision Structures
      1. Using the If Then Else Statement
      2. Nesting If Then Else Statements
    2. Using the Selection Structure in Word
      1. The TablesOfContents Collection
      2. Coding the CreateToc Procedure
  4. Custom Dialog Boxes
    1. User Forms
    2. Windows Standards
    3. Dialog Box Controls
    4. Adding a Form
      1. The Toolbox
      2. Sizing, Moving, Deleting, and Restoring a Control
      3. Using the Option Button, Check Box, and List Box Controls in Word
      4. UserForm's Initialize Event
      5. The Enter Button's Open Event Procedure
  5. Debugging and Error Handling
    1. Errors
    2. Automation and Error Trapping
      1. Using the GetObject Function
      2. Intercepting and Handling Run-time Errors
      3. Preventing Multiple Instances of an Application
    3. Using Automation and Error Trapping in Word
      1. Modifying the CreateCertificate Procedure
Class Materials

Each student will receive a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this Microsoft Word class:

  • Expertise in Microsoft Word
Live Private Class
  • Private Class for your Team
  • Live training
  • Online or On-location
  • Customizable
  • Expert Instructors
Request Proposal