O'Reilly logo

Special Edition Using® Microsoft® Office Excel 2003 by Patrick Blattner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required