back to top

This Visual Basic for Applications (VBA) training course is designed to give a good working knowledge of using Visual Basic with Microsoft Word.

The VBA content of the training course can be applied to other Microsoft Applications.

Delegates should have attended the Advanced Word Course.

Course Contents

Basics

  • Overview of Word VBA
  • Generating code by recording
  • The Word Object Model
  • The Visual Basic Editor
  • The Project Explorer
  • Creating sub procedures
  • Importance of comments
  • Printing your code

Manipulating text

  • Insert After/Before
  • Selecting text
  • Using the Text property
  • Retrieving text from a selection
  • Formatting a selection
  • Toggling formatting
  • Finding and replacing text

Objects, properties, methods

  • About objects and collections
  • Returning an object
  • Working with methods
  • Working with properties

Ranges

  • The Range object
  • Ranges and navigation
  • The Characters collection
  • The Words collection
  • The Sentences collection
  • The Paragraphs collection
  • The Font object
  • The ParagraphFormat object

Programming structures

  • Variables and constants
  • Declaring and typing variables
  • Using conditional structures
  • Using looping structures

Dialog boxes

  • Built-in dialog boxes
  • Dialog box settings
  • Capturing return values
  • Dialog box events

Controls

  • Overview of ActiveX controls
  • Creating userforms
  • Adding controls to a userform
  • Setting properties
  • Creating event procedures
  • Displaying a userform
  • Dismissing a userform
   
back to top
back to top

 

 

 

This page uses frames, but your browser doesn't support them.