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



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 2017