Hi All,

I want a message box to automatically appear if a given value i
entered in a cell. If I was writing a macro, I could do somethin
like...

If Range("a1").Value = "given value" Then
MsgBox ("my message")
End If

but I want the message box to appear automatically, ie without havin
to run a macro.

CHEERS for any hel

--
Message posted from http://www.ExcelForum.com