Special Edition Using® Microsoft® Office Excel 2003

Chapter 32. Creating Interactive Excel Applications with VBA

by Ken Cook

In this chapter

• Why Write Macros Rather Than Record Them?

• Introduction to Object-Oriented Programming

• Variables and Constants

• Understanding the Visual Basic Editor

• Getting Help with Visual Basic

• VBA Procedures

• Control Structures

• Code-Writing Tips

• Debugging

• Automatic Execution of VBA Code

Why Write Macros Rather Than Record Them?

The Macro Recorder enables you to create your own command macros in Excel by recording menu selections, keystrokes, and mouse movements. Recorded macros have their limitations, however. Following are a few things that can’t be recorded:

• Interaction—. You want the user to have input into how the macro will play back. Suppose that you create a workbook that charts ...