| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validate typed-in value against in-cell dropdown list
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Validate typed-in value against in-cell dropdown list
Why allow them to type in an entry if it must match the list?
" wrote: 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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Validate typed-in value against in-cell dropdown list
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Validate typed-in value against in-cell dropdown list
I've run into similar problems. Does anyone know how to resolve this?
|
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Validate typed-in value against in-cell dropdown list
It (XL2003) only values (to be typed) which are in the List so it is
self-validating. " wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| validate multiple cells in to one dropdown box | Excel Discussion (Misc queries) | |||
| result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
| Validate all cell values against it's list prior to saving the she | Excel Programming | |||
| Validate cell value against a list | Excel Programming | |||
| How to validate data in already list dropdown validated. | Excel Discussion (Misc queries) | |||
Hybrid Mode
