Chapter 32. Creating Interactive Excel Applications with VBA

by Ken Cook

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

Get Special Edition Using® Microsoft® Office Excel 2003 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.