Excel 97 Visual Basic for Applications

Course Overview

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

Excel 97 Advanced or equivalent.

Students will examine sample code, learn how to create macros from scratch, and add to previously created macros.

Students should already be confident in using the basic concepts of Excel and working with formulas and functions.

Introduction to Visual Basic Applications
Running a macro Recording a macro Examining module design
Assigning macros
Specifying the location of recorded macros Assigning shortcut keys to macros Assigning macros to menus Assigning a macro to a button on a sheet Assigning a macro to a button on a toolbar
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
User-defined functions and variables
Creating user-defined functions Using variables
Interactive macros
Creating a custom message box Creating a custom input box Previewing custom dialog boxes
Debugging and testing code
Overview of debugging Stepping through the code Using Watch Expressions
Macro management
Personal Macro Workbook Assigning Sub procedures to run automatically
Programmingbasics
Coding Variables Procedures Error handling Naming conventions

	Printer Friendly Version
	Download Outline As PDF

The trainer took the trouble to find out what we required before the course and adapted the material to our needs very well

- Gillette