software

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 quot;Warning have you though of...?quot;

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.

quot;Rachelquot; gt; wrote in message
...
gt; Is there anyway to set a warning message to pop up depending on what gets
gt; entered into a cell?
gt; For example if someone puts a number less than 100, can i program a pop up
gt; to say quot;Warning have you though of...?quot;
Checkou the Help section on Validation for a start.
--
Gary's Studentquot;Rachelquot; wrote:

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

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

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

quot;Gary''s Studentquot; gt; wrote
gt; Checkou the Help section on Validation for a start.
gt;
gt; quot;Rachelquot; wrote:
gt; gt; Is there anyway to set a warning message to pop up depending on what gets
gt; gt; entered into a cell?
gt; gt; For example if someone puts a number less than 100, can i program a pop up
gt; gt; to say quot;Warning have you though of...?quot;