DropDown

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jlmccabes - 09 Dec 2006 12:13 GMT

Need to be able to enter first several letters of a name and have the
dropdown pick them up as I type in the name. Had it on a demo worksheet in
my "learn" files BUT lost it somewhere. Please refer me to where I can
pick up some samples to use.. Thank You..

Reply to this Message

Nick Hodge - 09 Dec 2006 13:48 GMT

Ensure the AutoWordSelect property of the combobox is set to true (default)

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
www.nickhodge.co.uk

> Need to be able to enter first several letters of a name and have the
> dropdown pick them up as I type in the name. Had it on a demo worksheet
> in
> my "learn" files BUT lost it somewhere. Please refer me to where I can
> pick up some samples to use.. Thank You..

Reply to this Message

Debra Dalgleish - 09 Dec 2006 14:12 GMT

If you use a data validation dropdown list, it doesn't have AutoComplete.

You could use a combo box from the Control Toolbox
(View>Toolbars>Control Toolbox), and it will work as you described.

> Need to be able to enter first several letters of a name and have the
> dropdown pick them up as I type in the name. Had it on a demo worksheet in
> my "learn" files BUT lost it somewhere. Please refer me to where I can
> pick up some samples to use.. Thank You..

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message

Rate this thread: