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.