IF NOT or IS NOT function

N

Nick Wright

I am trying to write a macro to display a message if a certain cell does not
contain certain data. (I am working in Visual Basic)

i.e
If cell F1 = 100 then end
If cell F1 is not 100 then display a message "please re-enter data"

Can anyone please help
 
N

Nick

I do need a macro due to the code being written in an existing macro. I have
a sheet with 3 drop down menus. I have got everything to work when a print
preview button is pressed. I now want to idiot prove the program so that if
the numbers in a cell are changed the print preview macro will reconginse
this and display a message. How can i do this?
 
T

tina

Hi Nick
try using something like
If Range("f1") = 100 Then
Else
MsgBox ("please reenter data")
Exit Sub
End If
 
Top