Course Code:60.02
Course Subject:Excel Visual Basic for Applications
Course Title:Excel VBA Intermediate
Aims:To provide the student with the knowledge and confidence to write Visual Basic Code in the Excel environment.
Introduction:Visual Basic for Applications is based on the very popular Visual Basic programming language. It provides a means of controlling an Excel application (Workbooks, Worksheets, Ranges and Cells). 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 Excel objects way beyond conventional Spreadsheet 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 Excel 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. Use Standard Dialog Boxes

  1. Work with the File Open Dialog Box

  2. Work with the SaveAs Dialog Box

4. Work with Office Objects

  1. Understand the Office Object Model

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

  3. Search for files using the FileSearch Object