Microsoft VBA


Students will learn to create and edit macros, and gain an understanding of VBA code.


Windows Orientation, Excel 97: Worksheets (Windows 95), Excel 97: Advanced (Windows 95), Word 97: Level 1 (Windows 95), Word 97: Level 2 (Windows 95), and Word 97: Advanced (Windows 95) or equivalent knowledge.

What should you be familiar with?

Session Length

1 Day, 9:00am to 4:30pm


This session is conducted either on site, or at our training rooms.

Topics Covered in this session

          Introduction to Visual Basic for Applications
          Running a macro
          Recording a macro
          Examining module design

          Assigning macros

          Specifying the location of recorded macros
          Assigning macros to a menus, buttons, and toolbars

          Creating decision-making code

          The If...Then decision structure
          The If...Then...Else decision structure
          The Select Case decision structure

          Using loop structures

          Using a For...Next statement
          Using a Do...Loop statement
          Using a For Each...Next statement
          Macro management
          Personal Macro Workbook
          Assigning Sub procedures to run automatically

          Recording a macro in Word 97

          Running a macro
          Recording a macro

          Interactive macros

          Creating a custom message box
          Creating a custom input box
          Extracting data from Excel


          Macros in PowerPoint 97 and Access 97
          Debugging and testing code

Performance-based objectives
  • Run macros and explain the basics of a Visual Basic Module.
  • Create relative and absolute recorded macros and assign macros to various objects in a workbook.
  • Write procedures that test conditions and then run only certain statements based on the results.
  • Write procedures that execute one or more lines of code repetitively.
  • Store Excel macros so they are available in any workbook.
  • Create macros in Word 97.
  • Create macros that interact with the user

This course is not available on our public schedule, call us on 1800 456 002 or EMAIL to book this course

About our courses About Us Contact Us Education Outlines Schedule By Course© iTeam 2021