How about highlighting it in colour, that is Conditional Formatting?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Nikki" wrote in message
...
I want a message box to popup if a cell(which already contains a function)
is
over a certain value. Data validation won't work because the user isn't
entering data into the cell. What would be the best way to do this?
Basically- If A1134.16 then MsgBox "You are over your limit"
Thanks for the help!!
--
Thanks,
Nikki