can someone please help me with this

U

Uzma

I am trying to update a form that I created using excel. Now I have t
go back and modify some changes to it.

The change:
I need excel to pop up a message when I enter certain numbers in
cell. I want the numbers to be entered in the cell and then displa
the message as/using a pop up dialog box. I have tried using th
validation tool for this. However, it will not let me enter the valu
that I need in the cell but it will display the message. I am tryin
every idea that I have to get this form working, but none of them work
 
D

Debra Dalgleish

Select the cell (cell A2 in this example) in which you want the message.
Choose Data>Validation
From the Allow dropdown, choose Custom
In the formula box, type a formula that lists the numbers for which
you want to see a message (5, 10 and 15 in this example):
=AND(A2<>5,A2<>10,A2<>15)
Select the Error Alert tab
From the Style dropdown, choose Information
Type your message in the Error Message box
Click OK
 
Top