Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 2: Getting Around the Worksheet ... > Adding Data Entry Instructions with ...

Adding Data Entry Instructions with Input Messages

We've seen that Error Alerts tell the user if they've violated a data validation, and what they've done wrong. Input messages tell the user what sort of data is permitted in cells before the data is entered.

To demonstrate how this works:

  1. Select that same range of cells with which you've been working.
  2. Click Data Validation image Input Message. You'll see:
    images

    Figure 2–48. Delivering the message: The Input Message dialog box.

  3. Type Two-character limit in the Title field and “You must enter exactly two characters in this cell” in the Input Message field, and click OK.
  4. Click in any cell in the selected range; you'll see:
    images

    Figure 2–49. Proactive prompt: an input message

The idea is to pre-empt possible data entry mistakes, by letting the user know in advance what's allowed in the cells.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint