Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can Drop Down Boxes jump to the answer as you type?
If I create a form with VBA, to create a drop down box to have a list to pick
an answer for to fill in a cell in a worksheet, it will jump to the answer in the list as you type. Can a Data|Validation|List do the same thing? If not, is there a way to get that functionality in Excel? |
#2
|
|||
|
|||
Data Validation doesn't support autocomplete.
If you can use programming, there are instructions here for adding a combobox from which you can select one of the values from the data validation list. In the combobox, you can enable autocomplete: http://www.contextures.com/xlDataVal11.html rrucksdashel wrote: If I create a form with VBA, to create a drop down box to have a list to pick an answer for to fill in a cell in a worksheet, it will jump to the answer in the list as you type. Can a Data|Validation|List do the same thing? If not, is there a way to get that functionality in Excel? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Is there any way to modify this code to show the dropdown box while you are typing???? -- greenfalcon ------------------------------------------------------------------------ greenfalcon's Profile: http://www.excelforum.com/member.php...o&userid=13622 View this thread: http://www.excelforum.com/showthread...hreadid=466982 |
#4
|
|||
|
|||
Can Drop Down Boxes jump to the answer as you type?
were you able to resolve this. I am looking for the same functionality.
"greenfalcon" wrote: Is there any way to modify this code to show the dropdown box while you are typing???? -- greenfalcon ------------------------------------------------------------------------ greenfalcon's Profile: http://www.excelforum.com/member.php...o&userid=13622 View this thread: http://www.excelforum.com/showthread...hreadid=466982 |
#5
|
|||
|
|||
Can Drop Down Boxes jump to the answer as you type?
If you created the dropdown lists by using data validation, it doesn't
support autocomplete. If you can use programming, there are instructions here for adding a combobox from which you can select one of the values from the data validation list. In the combobox, you can enable autocomplete: http://www.contextures.com/xlDataVal11.html Hippy wrote: were you able to resolve this. I am looking for the same functionality. "greenfalcon" wrote: Is there any way to modify this code to show the dropdown box while you are typing???? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down Boxes in Excel | Excel Discussion (Misc queries) | |||
How do I create a macro to return drop down boxes to first item i. | Excel Discussion (Misc queries) | |||
Dynamic Drop Down Boxes | Excel Worksheet Functions | |||
Has anyone created forms in Excel with drop down boxes? | Excel Worksheet Functions | |||
Drop List Referencing | Excel Worksheet Functions |