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.

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.

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.

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.