software

Has anyone have much knowledge on data validation messages???

Hi Marcus,

Experience with such messages or not you should enter the entire message
into a Google Groups search to see what you find. At least give the entire\
message so someone can look up the message for you, and they are probably
going to have to look it up just like you would have to. BTW that means the
exact text including punctuation.

More information on Data Validation in general at
www.contextures.com/tiptech.html

and if you really don't know how to use a Google Groups search see
www.mvps.org/dmcritchie/excel/xlnews.htm
---
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;Marcusquot; gt; wrote in message ...
gt; Has anyone have much knowledge on data validation messages???

I'm sorry but you lost me. What do you mean?

quot;David McRitchiequot; wrote:

gt; Hi Marcus,
gt;
gt; Experience with such messages or not you should enter the entire message
gt; into a Google Groups search to see what you find. At least give the entire\
gt; message so someone can look up the message for you, and they are probably
gt; going to have to look it up just like you would have to. BTW that means the
gt; exact text including punctuation.
gt;
gt; More information on Data Validation in general at
gt; www.contextures.com/tiptech.html
gt;
gt; and if you really don't know how to use a Google Groups search see
gt; www.mvps.org/dmcritchie/excel/xlnews.htm
gt; ---
gt; HTH,
gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt; Search Page: www.mvps.org/dmcritchie/excel/search.htm
gt;
gt; quot;Marcusquot; gt; wrote in message ...
gt; gt; Has anyone have much knowledge on data validation messages???
gt;
gt;
gt;
gt;

There's information in Excel's Help, and he

www.contextures.com/xlDataVal04.html

If you give more detail on what you want to know, someone may be offer
specific advice.

Marcus wrote:
gt; Has anyone have much knowledge on data validation messages???--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.htmlgt; Has anyone have much knowledge on data validation messages???

If you mean the quot;Input Messagequot; and quot;Error Alertquot; tabs in the data
validation dialog box, there's info in Excel's built-in Help under
quot;Designate valid cell entries.quot;

Yes I am talking about the quot;Inout Messagequot;. The questions I have is if there
is more than one message for different cells, and the sheet is locked why
wont it change messages when you click a different cell?

quot;MyVeryOwnSelfquot; wrote:

gt; gt; Has anyone have much knowledge on data validation messages???
gt;
gt; If you mean the quot;Input Messagequot; and quot;Error Alertquot; tabs in the data
gt; validation dialog box, there's info in Excel's built-in Help under
gt; quot;Designate valid cell entries.quot;
gt;

read the information already supplied.
When you use validation you must correct the error.
The choice was made when you decided what is valid or not for
the validation. There are default messages and message that you
can create yourself.

Some more information on validation in
www.mvps.org/dmcritchie/excel/validation.htm

but Debra has several pages on validation at contextures.com
including the specific page she referenced.which is more directed
to the building of a validation and indirectly for the answer to your
question.

If you want to abort the entry try using Cancel button on the dialog
or the Esc key.

In an earlier part of the thread: If you don't know what I mean about
Google Groups, you should
read about search engines and Google web searches and Google Groups.
The Newsgroup should not be your primary source of information, because
practically every question that has been asked has been answered numerous
times year in and year out, and you could find most answers or at least get a
better handle on the question and answer by doing a search. Web pages
have a lot more information than someone can answer in a newsgroup thread.
---
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;Marcusquot; gt; wrote in message ...
gt; Yes I am talking about the quot;Inout Messagequot;. The questions I have is if there
gt; is more than one message for different cells, and the sheet is locked why
gt; wont it change messages when you click a different cell?
gt;
gt; quot;MyVeryOwnSelfquot; wrote:
gt;
gt; gt; gt; Has anyone have much knowledge on data validation messages???
gt; gt;
gt; gt; If you mean the quot;Input Messagequot; and quot;Error Alertquot; tabs in the data
gt; gt; validation dialog box, there's info in Excel's built-in Help under
gt; gt; quot;Designate valid cell entries.quot;
gt; gt;