An input message is a message that appears when a cell is selected. This message is optional, but strongly advised if your workbook will be used by more than one person.
You can write a message that allows the user to see the valid inputs, or valid input requirements, before they enter a value. The following is an example of an Input Message being shown on our Excel project.
Title: Positive Dollar Value
Input Message: Enter cash shortages as a negative number.
We have chosen to put an Input Message on this cell to clarify to the user of this Bonus Calculator that the value in B9 must be a negative number.
