| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
data validation shortcutting
does anyone know how i can do this?:
i have a data validation cell,used as a dropdown, and i want it to change to the first element when you type in a 1, and to the second element when you type in a 2 and so on. thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
data validation shortcutting
Hi Alexander
AFAIK this can't be done with the data validation listboxes. -- Regards Frank Kabel Frankfurt, Germany Alexander Jakopin wrote: does anyone know how i can do this?: i have a data validation cell,used as a dropdown, and i want it to change to the first element when you type in a 1, and to the second element when you type in a 2 and so on. thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
data validation shortcutting
Frank,
Just curious, What does AFAIK stand for? Have a nice day. Regards -----Original Message----- Hi Alexander AFAIK this can't be done with the data validation listboxes. -- Regards Frank Kabel Frankfurt, Germany Alexander Jakopin wrote: does anyone know how i can do this?: i have a data validation cell,used as a dropdown, and i want it to change to the first element when you type in a 1, and to the second element when you type in a 2 and so on. thanks . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
data validation shortcutting
Hi
AFAIK: As far as I know :-) -- Regards Frank Kabel Frankfurt, Germany anonymous wrote: Frank, Just curious, What does AFAIK stand for? Have a nice day. Regards -----Original Message----- Hi Alexander AFAIK this can't be done with the data validation listboxes. -- Regards Frank Kabel Frankfurt, Germany Alexander Jakopin wrote: does anyone know how i can do this?: i have a data validation cell,used as a dropdown, and i want it to change to the first element when you type in a 1, and to the second element when you type in a 2 and so on. thanks . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| custom data validation on cells with data validation values | Excel Worksheet Functions | |||
| Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
| Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
Linear Mode
