Validate typed-in value against in-cell dropdown list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

java2day@gmail.com - 25 Jan 2006 20:39 GMT

Hi,
I was wondering if anyone can help me out with this.

I have an in-cell dropdown list that I set up via Data/Validation menu.
All values in the list are uppercase. For example, "VISA, MASTER,
DISCOVER". So, user can either choose from the list or manually type
in the value.

When user manually type in a value, I have code in Worksheet_Change()
that will turn the value into uppercase. What I would like is to take
this value and validate against the values from the dropdown list.

Any help would be much appreciated.
Thanks.

Reply to this Message

Toppers - 25 Jan 2006 21:27 GMT

Why allow them to type in an entry if it must match the list?

> Hi,
> I was wondering if anyone can help me out with this.
[quoted text clipped - 10 lines]
> Any help would be much appreciated.
> Thanks.

Reply to this Message

java2day@gmail.com - 25 Jan 2006 22:01 GMT

Hi Toppers,
The user prefers it although it wasn't a hard requirement. To some of
them, typing it in is faster than using a mouse since they do it so
often.
Besides, when I used Data / Validation to set up the list, by default,
it allows the user to type in the value.
Thanks.

Reply to this Message

javabeans - 26 Jan 2006 00:54 GMT

I've run into similar problems. Does anyone know how to resolve this?

Reply to this Message

Toppers - 26 Jan 2006 16:32 GMT

It (XL2003) only values (to be typed) which are in the List so it is
self-validating.

> Hi Toppers,
> The user prefers it although it wasn't a hard requirement. To some of
[quoted text clipped - 3 lines]
> it allows the user to type in the value.
> Thanks.

Reply to this Message