Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop-Down List
I want to be able to do something like autocomplete through code - eg...
a user clicks in a cell and starts typing, and excel provides a drop-down box with the mostly likely text. any suggestions? -- When you lose your mind, you free your life. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop-Down List
Macros don't run when editing a cell - at least not for any practical
purpose. (I have seen a few useless demos to "prove a point"). The functionality you describe is inherent in a combobox from the control toolbox toolbar. You also might be able to wicker something in autoselect (but not using code). There is also the built in select from list, but this would only be germane if adding a value to the bottom of an existing list. -- Regards, Tom Ogilvy "ben" (remove this if mailing direct) wrote in message ... I want to be able to do something like autocomplete through code - eg... a user clicks in a cell and starts typing, and excel provides a drop-down box with the mostly likely text. any suggestions? -- When you lose your mind, you free your life. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop-Down List
oops forgot to mention, i want a list of text that i can populate myself, not
just a single line choice like autocomplete. Ben -- When you lose your mind, you free your life. "ben" wrote: I want to be able to do something like autocomplete through code - eg... a user clicks in a cell and starts typing, and excel provides a drop-down box with the mostly likely text. any suggestions? -- When you lose your mind, you free your life. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop-Down List
hmm,
forgot about the macros frozen when editing text. i guess i just have a pop list box on selection change. thanks anyway -- When you lose your mind, you free your life. "Tom Ogilvy" wrote: Macros don't run when editing a cell - at least not for any practical purpose. (I have seen a few useless demos to "prove a point"). The functionality you describe is inherent in a combobox from the control toolbox toolbar. You also might be able to wicker something in autoselect (but not using code). There is also the built in select from list, but this would only be germane if adding a value to the bottom of an existing list. -- Regards, Tom Ogilvy "ben" (remove this if mailing direct) wrote in message ... I want to be able to do something like autocomplete through code - eg... a user clicks in a cell and starts typing, and excel provides a drop-down box with the mostly likely text. any suggestions? -- When you lose your mind, you free your life. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down list based on other drop down list pick | Excel Discussion (Misc queries) | |||
Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |