software

I need to have a list of OEMs to choose from. Once that is done I want the
next list to be only that OEM's products. I also need to have the ability to
have a quot;write inquot;, for quot;in-the-fieldquot; use, instead of having the user go into
the data table. I will add permanent listings to the data table.

See

www.contextures.com/xlDataVal02.html

In article gt;,
Jono gt; wrote:

gt; I need to have a list of OEMs to choose from. Once that is done I want the
gt; next list to be only that OEM's products. I also need to have the ability to
gt; have a quot;write inquot;, for quot;in-the-fieldquot; use, instead of having the user go into
gt; the data table. I will add permanent listings to the data table.

Thank you for your reply.
I tried it and it does the first part of my question. The problem is, that
even if I leave a blank line at the top of the list, when the sheet is
protected it won't let you type anything into the field, unlike a combobox.
If I leave the sheet unprotected I can type something into the quot;categoryquot;
field but when I try to enter something into the quot;itemquot; field it gives me the
following error, quot;The value you entered is not valid.quot;, quot;A user has
restricted values that can be entered into this cell.quot;
What it seems I need is to do this data validation with comboboxes. Is there
any way to do that?

quot;JE McGimpseyquot; wrote:

gt; See
gt;
gt; www.contextures.com/xlDataVal02.html
gt;
gt; In article gt;,
gt; Jono gt; wrote:
gt;
gt; gt; I need to have a list of OEMs to choose from. Once that is done I want the
gt; gt; next list to be only that OEM's products. I also need to have the ability to
gt; gt; have a quot;write inquot;, for quot;in-the-fieldquot; use, instead of having the user go into
gt; gt; the data table. I will add permanent listings to the data table.
gt;

Either *name* your list, and enter the name in the quot;Sourcequot; box as:
=listname
OR
Under the quot;Error Alertquot; tab, *uncheck*
'Show Error Alert After Invalid data Is Entered'

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

quot;Jonoquot; gt; wrote in message
...
Thank you for your reply.
I tried it and it does the first part of my question. The problem is, that
even if I leave a blank line at the top of the list, when the sheet is
protected it won't let you type anything into the field, unlike a combobox.
If I leave the sheet unprotected I can type something into the quot;categoryquot;
field but when I try to enter something into the quot;itemquot; field it gives me
the
following error, quot;The value you entered is not valid.quot;, quot;A user has
restricted values that can be entered into this cell.quot;
What it seems I need is to do this data validation with comboboxes. Is there
any way to do that?

quot;JE McGimpseyquot; wrote:

gt; See
gt;
gt; www.contextures.com/xlDataVal02.html
gt;
gt; In article gt;,
gt; Jono gt; wrote:
gt;
gt; gt; I need to have a list of OEMs to choose from. Once that is done I want
the
gt; gt; next list to be only that OEM's products. I also need to have the
ability to
gt; gt; have a quot;write inquot;, for quot;in-the-fieldquot; use, instead of having the user go
into
gt; gt; the data table. I will add permanent listings to the data table.
gt;