Allow other values other than ones in Value List

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Corey - 30 May 2006 01:07 GMT

Is there a way i can be permitted to add values to a drop down value list of
a cell?
If the value is not in the list at present i get a "The value you entered is
not valid" error.
I do not want to add that particular value to the list each time as it may
never be used again, and the list would grow beyond the never never....

Any idea's?

Reply to this Message

Paul B - 30 May 2006 01:17 GMT

Corey, if this is from data validation uncheck show error alert on the error
alert tab in data validation

Signature

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

> Is there a way i can be permitted to add values to a drop down value list of
> a cell?
[quoted text clipped - 4 lines]
>
> Any idea's?

Reply to this Message

Corey - 30 May 2006 01:24 GMT

Thanks Paul B.
Simple as that. ERROR ALERT was ON.
I should get in the practice of reading ALL the Tabs on windows.

Cheers

Corey....

> Corey, if this is from data validation uncheck show error alert on the
> error
[quoted text clipped - 11 lines]
>>
>> Any idea's?

Reply to this Message

Paul B - 30 May 2006 03:31 GMT

your welcome, thanks for the feedback

Signature

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

> Thanks Paul B.
> Simple as that. ERROR ALERT was ON.
[quoted text clipped - 18 lines]
> >>
> >> Any idea's?

Reply to this Message

Ron Coderre - 30 May 2006 01:18 GMT

Try this:

Select the cell(s) to be impacted by this change

From the Excel main menu:
<data><validation><error alert tab>
(assuming you already have the validation part working)
Set the Style to: Warning or Information (instead of Stop)
Set the warning message (eg "That item is not on the list...continue?")

That way, non-list entries will trigger a warning, but will still be
accepted if the user chooses.

Does that help?
***********
Regards,
Ron

XL2002, WinXP

> Is there a way i can be permitted to add values to a drop down value list of
> a cell?
[quoted text clipped - 4 lines]
>
> Any idea's?

Reply to this Message

Dave Peterson - 30 May 2006 01:20 GMT

Are you using Data|Validation.

If you are, you can change the message/prompt and the style (from Stop to
Warning or Information):

Data|Validation|Error Alert tab.

> Is there a way i can be permitted to add values to a drop down value list of
> a cell?
[quoted text clipped - 4 lines]
>
> Any idea's?

Signature

Dave Peterson

Reply to this Message