software

I am looking at validation to see if I can make a error message pop up
only when the user clicks a different sheet or attempts to save as I
don’t want to annoy people with having to constantly click on message
boxes. Is this possible?--
caliskier
------------------------------------------------------------------------
caliskier's Profile: www.excelforum.com/member.php...oamp;userid=25887
View this thread: www.excelforum.com/showthread...hreadid=502939Not using Data|Validation, but you could use worksheet_deactivate or
workbook_beforesave (or workbook_beforeclose) to run code that validates the
user's input.

But I don't think I'd bother -- lots of things could go wrong (user choosing not
to enable macros or disabling events).

I'd use an adjacent cell and just put a formula that checks:

=if(isnumber(a1),quot;quot;,quot;Please put a number in A1!quot;)

format it in big red letters and the error will be seen immediately.

caliskier wrote:
gt;
gt; I am looking at validation to see if I can make a error message pop up
gt; only when the user clicks a different sheet or attempts to save as I
gt; don’t want to annoy people with having to constantly click on message
gt; boxes. Is this possible?
gt;
gt; --
gt; caliskier
gt; ------------------------------------------------------------------------
gt; caliskier's Profile: www.excelforum.com/member.php...oamp;userid=25887
gt; View this thread: www.excelforum.com/showthread...hreadid=502939

--

Dave Peterson


Thanks, apreciate the help--
caliskier
------------------------------------------------------------------------
caliskier's Profile: www.excelforum.com/member.php...oamp;userid=25887
View this thread: www.excelforum.com/showthread...hreadid=502939Validation won't do it.

You need VBA event code.

See Chip Pearson's site for event code instructions specificaly
worksheet_deactivate and workbook_beforesave

www.cpearson.com/excel/events.htm

And David McRitchie's site.

www.mvps.org/dmcritchie/excel/event.htmGord Dibben MS Excel MVP

On Thu, 19 Jan 2006 10:22:08 -0600, caliskier
gt; wrote:

gt;
gt;I am looking at validation to see if I can make a error message pop up
gt;only when the user clicks a different sheet or attempts to save as I
gt;don’t want to annoy people with having to constantly click on message
gt;boxes. Is this possible?