The DataValidation menu will allow you to do that

Look in Help for details and examples

--
Kind regards,

Niek Otten

"Mr. Walker" <Mr. wrote in message
...
I want to know how to create an excel response such that if someone
manually
enters in a value that is too high, an automatic response...perhaps in pop
up
icon with only the "OK" button....is immediately excel response. I have
not
created macros before.