View Single Post
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

What kind of message box, Nick?
You could do something like this if the certain cell was A1...
=IF(ISBLANK(A1),"","Message")
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Nick Wright" <Nick wrote in message
...
I am trying to do an if function so if a certain cell has certain data
nothing happens, but if the data in the cell is different a message box is
displayed.

Can anyone please help