software

I have a simple list of categories that I have put into a drop down list. I
have checked off the Error Alert box under validation and entered a warning
message. I want to force the user to either choose a category from the drop
down list or type it exactly as it appears in the drop down. From all I've
read it seems that all I have to do is check that Error Alert box, but it's
not working. I have tested it and when I enter something that is not part of
the list it just lets me continue. No warning message or anything.

What am I doing wrong?

Phyllis

Be sure you set the Data gt; Validation feature for quot;Allow Listquot;.....then it
will only permit those items on the list, which you establish elsewhere, out
of the way.

Vaya con Dios,
Chuck, CABGx3
quot;Phyllisquot; wrote:

gt; I have a simple list of categories that I have put into a drop down list. I
gt; have checked off the Error Alert box under validation and entered a warning
gt; message. I want to force the user to either choose a category from the drop
gt; down list or type it exactly as it appears in the drop down. From all I've
gt; read it seems that all I have to do is check that Error Alert box, but it's
gt; not working. I have tested it and when I enter something that is not part of
gt; the list it just lets me continue. No warning message or anything.
gt;
gt; What am I doing wrong?
gt;
gt; Phyllis

I the quot;Show Error alert after invalid data is enteredquot; checked off? If it
isn't, no error message will appear.
--
Kevin Backmannquot;Phyllisquot; wrote:

gt; I have a simple list of categories that I have put into a drop down list. I
gt; have checked off the Error Alert box under validation and entered a warning
gt; message. I want to force the user to either choose a category from the drop
gt; down list or type it exactly as it appears in the drop down. From all I've
gt; read it seems that all I have to do is check that Error Alert box, but it's
gt; not working. I have tested it and when I enter something that is not part of
gt; the list it just lets me continue. No warning message or anything.
gt;
gt; What am I doing wrong?
gt;
gt; Phyllis

Yes, this is checked off.

Phyllis

quot;Kevin Bquot; wrote:

gt; I the quot;Show Error alert after invalid data is enteredquot; checked off? If it
gt; isn't, no error message will appear.
gt; --
gt; Kevin Backmann
gt;
gt;
gt; quot;Phyllisquot; wrote:
gt;
gt; gt; I have a simple list of categories that I have put into a drop down list. I
gt; gt; have checked off the Error Alert box under validation and entered a warning
gt; gt; message. I want to force the user to either choose a category from the drop
gt; gt; down list or type it exactly as it appears in the drop down. From all I've
gt; gt; read it seems that all I have to do is check that Error Alert box, but it's
gt; gt; not working. I have tested it and when I enter something that is not part of
gt; gt; the list it just lets me continue. No warning message or anything.
gt; gt;
gt; gt; What am I doing wrong?
gt; gt;
gt; gt; Phyllis

I have quot;Listquot; chosen.

Phyllis

quot;CLRquot; wrote:

gt; Be sure you set the Data gt; Validation feature for quot;Allow Listquot;.....then it
gt; will only permit those items on the list, which you establish elsewhere, out
gt; of the way.
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;Phyllisquot; wrote:
gt;
gt; gt; I have a simple list of categories that I have put into a drop down list. I
gt; gt; have checked off the Error Alert box under validation and entered a warning
gt; gt; message. I want to force the user to either choose a category from the drop
gt; gt; down list or type it exactly as it appears in the drop down. From all I've
gt; gt; read it seems that all I have to do is check that Error Alert box, but it's
gt; gt; not working. I have tested it and when I enter something that is not part of
gt; gt; the list it just lets me continue. No warning message or anything.
gt; gt;
gt; gt; What am I doing wrong?
gt; gt;
gt; gt; Phyllis

Have you validated the quot;listquot; by clicking it in to the quot;sourcequot; window
provided?

Vaya con Dios,
Chuck, CABGx3
quot;Phyllisquot; wrote:

gt; I have quot;Listquot; chosen.
gt;
gt; Phyllis
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; Be sure you set the Data gt; Validation feature for quot;Allow Listquot;.....then it
gt; gt; will only permit those items on the list, which you establish elsewhere, out
gt; gt; of the way.
gt; gt;
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Phyllisquot; wrote:
gt; gt;
gt; gt; gt; I have a simple list of categories that I have put into a drop down list. I
gt; gt; gt; have checked off the Error Alert box under validation and entered a warning
gt; gt; gt; message. I want to force the user to either choose a category from the drop
gt; gt; gt; down list or type it exactly as it appears in the drop down. From all I've
gt; gt; gt; read it seems that all I have to do is check that Error Alert box, but it's
gt; gt; gt; not working. I have tested it and when I enter something that is not part of
gt; gt; gt; the list it just lets me continue. No warning message or anything.
gt; gt; gt;
gt; gt; gt; What am I doing wrong?
gt; gt; gt;
gt; gt; gt; Phyllis

How is your list referred to

=$A$1:$A$10

=MyList

or something else, if you type in the list values directly you don't need
the equal sign
but you need to use comma as delimiter
--
Regards,

Peo Sjoblom

Portland, Oregon

quot;Phyllisquot; gt; wrote in message
...
gt; Yes, this is checked off.
gt;
gt; Phyllis
gt;
gt; quot;Kevin Bquot; wrote:
gt;
gt;gt; I the quot;Show Error alert after invalid data is enteredquot; checked off? If
gt;gt; it
gt;gt; isn't, no error message will appear.
gt;gt; --
gt;gt; Kevin Backmann
gt;gt;
gt;gt;
gt;gt; quot;Phyllisquot; wrote:
gt;gt;
gt;gt; gt; I have a simple list of categories that I have put into a drop down
gt;gt; gt; list. I
gt;gt; gt; have checked off the Error Alert box under validation and entered a
gt;gt; gt; warning
gt;gt; gt; message. I want to force the user to either choose a category from the
gt;gt; gt; drop
gt;gt; gt; down list or type it exactly as it appears in the drop down. From all
gt;gt; gt; I've
gt;gt; gt; read it seems that all I have to do is check that Error Alert box, but
gt;gt; gt; it's
gt;gt; gt; not working. I have tested it and when I enter something that is not
gt;gt; gt; part of
gt;gt; gt; the list it just lets me continue. No warning message or anything.
gt;gt; gt;
gt;gt; gt; What am I doing wrong?
gt;gt; gt;
gt;gt; gt; PhyllisThe user can always clear contents of that data|validation cell.

You could have some worksheet event that issues a warning when it's cleared...

But I just like to use an adjacent cell with:

=if(a1lt;gt;quot;quot;,quot;quot;,quot;Please fill in A1!quot;)

I make it big, bold, red letters.

Phyllis wrote:
gt;
gt; I have a simple list of categories that I have put into a drop down list. I
gt; have checked off the Error Alert box under validation and entered a warning
gt; message. I want to force the user to either choose a category from the drop
gt; down list or type it exactly as it appears in the drop down. From all I've
gt; read it seems that all I have to do is check that Error Alert box, but it's
gt; not working. I have tested it and when I enter something that is not part of
gt; the list it just lets me continue. No warning message or anything.
gt;
gt; What am I doing wrong?
gt;
gt; Phyllis

--

Dave Peterson

I'm not sure if I know what you mean by validating it in the quot;sourcequot; window,
but I do have the list name in the quot;sourcequot; section of the quot;data validationquot;
area. Is this what you mean?

Phyllis

quot;CLRquot; wrote:

gt; Have you validated the quot;listquot; by clicking it in to the quot;sourcequot; window
gt; provided?
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;Phyllisquot; wrote:
gt;
gt; gt; I have quot;Listquot; chosen.
gt; gt;
gt; gt; Phyllis
gt; gt;
gt; gt; quot;CLRquot; wrote:
gt; gt;
gt; gt; gt; Be sure you set the Data gt; Validation feature for quot;Allow Listquot;.....then it
gt; gt; gt; will only permit those items on the list, which you establish elsewhere, out
gt; gt; gt; of the way.
gt; gt; gt;
gt; gt; gt; Vaya con Dios,
gt; gt; gt; Chuck, CABGx3
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Phyllisquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I have a simple list of categories that I have put into a drop down list. I
gt; gt; gt; gt; have checked off the Error Alert box under validation and entered a warning
gt; gt; gt; gt; message. I want to force the user to either choose a category from the drop
gt; gt; gt; gt; down list or type it exactly as it appears in the drop down. From all I've
gt; gt; gt; gt; read it seems that all I have to do is check that Error Alert box, but it's
gt; gt; gt; gt; not working. I have tested it and when I enter something that is not part of
gt; gt; gt; gt; the list it just lets me continue. No warning message or anything.
gt; gt; gt; gt;
gt; gt; gt; gt; What am I doing wrong?
gt; gt; gt; gt;
gt; gt; gt; gt; Phyllis

Hi Peo,

I refer to my list by: =Category

quot;Peo Sjoblomquot; wrote:

gt; How is your list referred to
gt;
gt; =$A$1:$A$10
gt;
gt; =MyList
gt;
gt; or something else, if you type in the list values directly you don't need
gt; the equal sign
gt; but you need to use comma as delimiter
gt;
gt;
gt;
gt; --
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;Phyllisquot; gt; wrote in message
gt; ...
gt; gt; Yes, this is checked off.
gt; gt;
gt; gt; Phyllis
gt; gt;
gt; gt; quot;Kevin Bquot; wrote:
gt; gt;
gt; gt;gt; I the quot;Show Error alert after invalid data is enteredquot; checked off? If
gt; gt;gt; it
gt; gt;gt; isn't, no error message will appear.
gt; gt;gt; --
gt; gt;gt; Kevin Backmann
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Phyllisquot; wrote:
gt; gt;gt;
gt; gt;gt; gt; I have a simple list of categories that I have put into a drop down
gt; gt;gt; gt; list. I
gt; gt;gt; gt; have checked off the Error Alert box under validation and entered a
gt; gt;gt; gt; warning
gt; gt;gt; gt; message. I want to force the user to either choose a category from the
gt; gt;gt; gt; drop
gt; gt;gt; gt; down list or type it exactly as it appears in the drop down. From all
gt; gt;gt; gt; I've
gt; gt;gt; gt; read it seems that all I have to do is check that Error Alert box, but
gt; gt;gt; gt; it's
gt; gt;gt; gt; not working. I have tested it and when I enter something that is not
gt; gt;gt; gt; part of
gt; gt;gt; gt; the list it just lets me continue. No warning message or anything.
gt; gt;gt; gt;
gt; gt;gt; gt; What am I doing wrong?
gt; gt;gt; gt;
gt; gt;gt; gt; Phyllis
gt;
gt;