Comments/Warning fields
 

Is there anyway to set a warning message to pop up depending on what gets
entered into a cell?
For example if someone puts a number less than 100, can i program a pop up
to say "Warning have you though of...?"

Comments/Warning fields
 

Hi

You probably can with VBA programming. An alternative would be to use a
helper cell with a formula in, or conditional formatting, or even a data
validation message.
Post back if you need any further guidance.

Andy.

"Rachel" wrote in message
...
Is there anyway to set a warning message to pop up depending on what gets
entered into a cell?
For example if someone puts a number less than 100, can i program a pop up
to say "Warning have you though of...?"

Comments/Warning fields
 

Checkou the Help section on Validation for a start.
--
Gary's Student


"Rachel" wrote:

Is there anyway to set a warning message to pop up depending on what gets
entered into a cell?
For example if someone puts a number less than 100, can i program a pop up
to say "Warning have you though of...?"

Comments/Warning fields
 

Hi Rachel,
For specific help with validation see (look for validation)
A nice intro video usable even if you don't have broadband
http://www.datapigtechnologies.com/ExcelMain.htm
and for in-depth coverage
http://www.contextures.com/tiptech.html

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Gary''s Student" wrote
Checkou the Help section on Validation for a start.

"Rachel" wrote:
Is there anyway to set a warning message to pop up depending on what gets
entered into a cell?
For example if someone puts a number less than 100, can i program a pop up
to say "Warning have you though of...?"