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 ...
Get Absolute Beginner's Guide to VBA 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.
