Course Code:61.02
Course Subject:Word Visual Basic for Applications
Course Title:Word VBA Intermediate
Aims:To provide the student with the knowledge and confidence to write Visual Basic Code in the Word environment.
Introduction:Visual Basic for Applications is based on the very popular Visual Basic programming language. It provides a means of controlling a Word application (Documents, Paragraphs and Ranges (Words)). The key difference between VBA and Visual Basic is that VBA resides within Microsoft applications like Excel, Word, Visio etc. whereas Visual Basic is a standalone application. VBA code allows the programmer to implement functions and take control of Word objects way beyond conventional Word Processing use. This course is intended to provide the student with the knowledge and ability to build on the topics covered in the Introduction level course and use the more sophisticated features available in the Word Visual Basic environment. This is an intensive course and prior knowledge of the basics of Visual Basic coding is required..
  

Objectives

The learner will be able to:

Assessment Criteria

The learner has achieved this objective because he/she can:

1. Use the Visual Basic Editor

  1. Navigate the Code or Module Window

  2. Run a Single Line of Code using the Immediate Window

  3. Monitor Variable Values using the Locals Windows

  4. Look-up Properties, Methods etc. using the Object Browser

  5. Monitor Variable Values using the Watch Window

  6. Check a Variable Value using the Quick Watch Window

  7. Run Code

  8. Implement Breakpoints

  9. Understand Break Mode

10. Insert Bookmarks

11. Execute a different Next Statement

12. Use Conditional Compilation

2. Implement User Forms

  1. Create a Form

  2. Design Form

  3. Work with Controls

  4. Understand the range of Controls

  5. Rounding-Off a Form

  6. Use the Design Tools

3. Create and control Command Bars

  1. Understand the principles

  2. Create and Modify Command Bars (Menu Bar, Toolbar Bar or Shortcut Bar)

  3. Create and Modify Command Bar Controls (Button, Box or Pop-up)