Microsoft VBA Introduction

Outcomes

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

Prerequisites

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

Location

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 Appendix 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