I'd like to save time selecting from a drop down list by typing the first few
letters of textl and have the cell "auto fill."

If you are using a combobox from the controls menu, set the
AutoWordSelect property to True. If you are using a data
validation dropdown, you can't do this.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Excel Novice" <Excel wrote in
message
...
I'd like to save time selecting from a drop down list by typing
the first few
letters of textl and have the cell "auto fill."

Chip,

I am also interested in doing this. Is there a good tutorial on setting up a
combobox from the controls menu so that the user can just type some text to
select an entry?

Phil.

"Chip Pearson" wrote:

If you are using a combobox from the controls menu, set the
AutoWordSelect property to True. If you are using a data
validation dropdown, you can't do this.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Excel Novice" <Excel wrote in
message
...
I'd like to save time selecting from a drop down list by typing
the first few
letters of textl and have the cell "auto fill."

Phil

Should be all you need at Debra Dalgleish's site.

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP

On Mon, 12 Jun 2006 07:57:02 -0700, Phil wrote:

Chip,

I am also interested in doing this. Is there a good tutorial on setting up a
combobox from the controls menu so that the user can just type some text to
select an entry?

Phil.

"Chip Pearson" wrote:

If you are using a combobox from the controls menu, set the
AutoWordSelect property to True. If you are using a data
validation dropdown, you can't do this.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Excel Novice" <Excel wrote in
message
...
I'd like to save time selecting from a drop down list by typing
the first few
letters of textl and have the cell "auto fill."

Hi Gord,

I referenced the site you recommended and found it helpful. Unfortunately,
I can not get the combo box to reference the drop down list - it pops up
empty. I am curious whether the macro code needs modification because I am
linking validation list from another workbook. I do have it open when
attempting to execute. Any recommendations would be greatly appreciated.
Thanks, Jim

"Gord Dibben" wrote:

Phil

Should be all you need at Debra Dalgleish's site.

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP

On Mon, 12 Jun 2006 07:57:02 -0700, Phil wrote:

Chip,

I am also interested in doing this. Is there a good tutorial on setting up a
combobox from the controls menu so that the user can just type some text to
select an entry?

Phil.

"Chip Pearson" wrote:

If you are using a combobox from the controls menu, set the
AutoWordSelect property to True. If you are using a data
validation dropdown, you can't do this.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Excel Novice" <Excel wrote in
message
...
I'd like to save time selecting from a drop down list by typing
the first few
letters of textl and have the cell "auto fill."

Did you first create the Data Validation dropdowns as instructed?

Since you're using another workbook for the source, make sure you use a
named range from that workbook as your list source.

http://www.contextures.on.ca/xlDataVal05.html

A sample workbook can be found at Debra's site

http://www.contextures.on.ca/excelfiles.html#DataVal

DV0028 - Data Validation Combobox Named Lists -- Double-click a cell that
contains a data validation list, and a combobox appears -- font size can be
set, more than 8 rows displayed, autocomplete can be enabled. Lists are
stored in named ranges on a separate sheet. Macros must be enabled.
DataValComboboxSheet.zip 13 kb updated 15-Jan-07 View detailed
Instructions

Another one from same site.............

DV0043 - Data Validation Combobox With Entry Check -- Double-click a cell
that contains a data validation list, and a combobox appears -- font size
can be set, more than 8 rows displayed, autocomplete can be enabled. When
the combobox loses focus, the entry is validated. DataValComboCheck.zip 15
kb 29-Jun-06 Updated 11-Oct-06


Gord

On Tue, 9 Sep 2008 20:06:01 -0700, Jim
wrote:

Hi Gord,

I referenced the site you recommended and found it helpful. Unfortunately,
I can not get the combo box to reference the drop down list - it pops up
empty. I am curious whether the macro code needs modification because I am
linking validation list from another workbook. I do have it open when
attempting to execute. Any recommendations would be greatly appreciated.
Thanks, Jim

"Gord Dibben" wrote:

Phil

Should be all you need at Debra Dalgleish's site.

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP

On Mon, 12 Jun 2006 07:57:02 -0700, Phil wrote:

Chip,

I am also interested in doing this. Is there a good tutorial on setting up a
combobox from the controls menu so that the user can just type some text to
select an entry?

Phil.

"Chip Pearson" wrote:

If you are using a combobox from the controls menu, set the
AutoWordSelect property to True. If you are using a data
validation dropdown, you can't do this.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Excel Novice" <Excel wrote in
message
...
I'd like to save time selecting from a drop down list by typing
the first few
letters of textl and have the cell "auto fill."