| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic cell validation prefill by entering first letter
Hi
I have set up a dropdown list validation in a cell. I would like to set it up so that users can type the first letter of the option they want in the cell and have it prefill the first option in the list that begins with that letter. Is this possible? Thank you for any help you can provide. :) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic cell validation prefill by entering first letter
You can't do that with validation, the combobox from the control toolbox can
be configured to do that -- Regards, Peo Sjoblom "JB" wrote in message ... Hi I have set up a dropdown list validation in a cell. I would like to set it up so that users can type the first letter of the option they want in the cell and have it prefill the first option in the list that begins with that letter. Is this possible? Thank you for any help you can provide. :) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic cell validation prefill by entering first letter
Contextures has some good info on this:
http://www.contextures.com/xlDataVal10.html "JB" wrote: Hi I have set up a dropdown list validation in a cell. I would like to set it up so that users can type the first letter of the option they want in the cell and have it prefill the first option in the list that begins with that letter. Is this possible? Thank you for any help you can provide. :) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic cell validation prefill by entering first letter
Thanks Peo! I've changed it over to a combobox, the only problem I'm having
now is that i can't get it so that users can get to it by hitting tab, like in a form (not just by using the mouse) Any ideas? "Peo Sjoblom" wrote: You can't do that with validation, the combobox from the control toolbox can be configured to do that -- Regards, Peo Sjoblom "JB" wrote in message ... Hi I have set up a dropdown list validation in a cell. I would like to set it up so that users can type the first letter of the option they want in the cell and have it prefill the first option in the list that begins with that letter. Is this possible? Thank you for any help you can provide. :) |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic cell validation prefill by entering first letter
Haven't got time right this minute to layout the code, but I'm thinking that
if you use the worksheet's _SelectionChange event processing to see if someone has tabbed into a specific cell and when they do that have the 'focus' set to the combo box? Need help with the code, post back. "JB" wrote: Thanks Peo! I've changed it over to a combobox, the only problem I'm having now is that i can't get it so that users can get to it by hitting tab, like in a form (not just by using the mouse) Any ideas? "Peo Sjoblom" wrote: You can't do that with validation, the combobox from the control toolbox can be configured to do that -- Regards, Peo Sjoblom "JB" wrote in message ... Hi I have set up a dropdown list validation in a cell. I would like to set it up so that users can type the first letter of the option they want in the cell and have it prefill the first option in the list that begins with that letter. Is this possible? Thank you for any help you can provide. :) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| New Validation option to format 1st letter as Capital letter | Excel Discussion (Misc queries) | |||
| Automatic scientific format when entering 5E100 | Excel Discussion (Misc queries) | |||
| change a cell colour when entering a letter | New Users to Excel | |||
| How do I convert dollars and cents to text, and prefill the cell . | Excel Worksheet Functions | |||
| letter Validation | Excel Worksheet Functions | |||
Linear Mode
