Chapter 12. Interacting with the User

     

Chapter 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 feels that he or she is a part of the process and has some control over what the program does or doesn't do ”which means that the user won't lose interest in the program and will be less likely to make careless mistakes. This chapter takes you through various methods of giving and receiving user feedback.



Absolute Beginner's Guide to VBA
Absolute Beginners Guide to VBA
ISBN: 0789730766
EAN: 2147483647
Year: 2003
Pages: 146

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net