The input message is intended to provide guidance to the worksheet user.- In the Title box, type Enter Limit. In the Input Message box, type Please enter
the customer’s credit limit, omitting the dollar sign and any commas. - Click the Error Alert tab. On the Error Alert page, in the Style list, click Stop.
The icon that appears on your message box changes to the Stop icon.You can enter a custom error message or use the default message for this type of error.- In the Title box, type Error, and then click OK.
- Click cell J7.
A ScreenTip with the title Enter Limit and the text Please enter the customer’s credit
limit, omitting the dollar sign and any commas appears near cell J7.Defining Valid Sets of Values for Ranges of Cells 365