O'Reilly logo

Absolute Beginner's Guide to VBA by Paul McFedries

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

12. Interacting with the User

In This Chapter

Getting the user's attention with sounds

Displaying messages in the program's status bar

• Displaying a simple dialog box to the user

Prompting the user for text, numbers, or other input

Taking advantage of Word and Excel's built-in dialog boxes

Most of your VBA programs will be for your own use only, although once you get proficient at coding, you may find yourself cobbling together macros and functions for other people, as well. Either way, it's important to remember that a well-designed program keeps the user (whoever he or she may be) involved by displaying messages at appropriate times and by asking for input. The advantage to using these and other forms of interaction is that the user ...

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