Okay,

I am stumped here.

I have a data validation drop down as a list format. Since the list
is over 5000 unique entries, I want to be able to start typing the
value and have it start to go there. However, whenever I start to
type the value, it won't let me. I have another list validation on
the same file that does this and cannot figure it out.

Any ideas?

Thanks!

Use a Combo box - Debra Dalgleish shows how he

http://www.contextures.com/xlDataVal10.html

Hope this helps.

Pete

On Dec 29, 2:00*pm, DonkeyKong wrote:
Okay,

I am stumped here.

I have a data validation drop down as a list format. *Since the list
is over 5000 unique entries, I want to be able to start typing the
value and have it start to go there. *However, whenever I start to
type the value, it won't let me. *I have another list validation on
the same file that does this and cannot figure it out.

Any ideas?

Thanks!

On Dec 29, 9:44*am, Pete_UK wrote:
Use a Combo box - Debra Dalgleish shows how he

http://www.contextures.com/xlDataVal10.html

Hope this helps.

Pete

On Dec 29, 2:00*pm, DonkeyKong wrote:



Okay,

I am stumped here.

I have a data validation drop down as a list format. *Since the list
is over 5000 unique entries, I want to be able to start typing the
value and have it start to go there. *However, whenever I start to
type the value, it won't let me. *I have another list validation on
the same file that does this and cannot figure it out.

Any ideas?

Thanks!- Hide quoted text -

- Show quoted text -

Pete, is there another way to do this? Because then I need to
reference what is in that cell - similar to a vlookup situation and
don't want to get in to the VB, though I could do it that way - just
wanted to know if it was easier...

Use a combo box from the control toolbox. It has autocomplete capabilities
and *doesn't* need a VBA interface. You set the autocomplete option in the
Properties.

--
Biff
Microsoft Excel MVP


"DonkeyKong" wrote in message
...
On Dec 29, 9:44 am, Pete_UK wrote:
Use a Combo box - Debra Dalgleish shows how he

http://www.contextures.com/xlDataVal10.html

Hope this helps.

Pete

On Dec 29, 2:00 pm, DonkeyKong wrote:



Okay,

I am stumped here.

I have a data validation drop down as a list format. Since the list
is over 5000 unique entries, I want to be able to start typing the
value and have it start to go there. However, whenever I start to
type the value, it won't let me. I have another list validation on
the same file that does this and cannot figure it out.

Any ideas?

Thanks!- Hide quoted text -

- Show quoted text -

Pete, is there another way to do this? Because then I need to
reference what is in that cell - similar to a vlookup situation and
don't want to get in to the VB, though I could do it that way - just
wanted to know if it was easier...

On Dec 29, 12:29*pm, "T. Valko" wrote:
Use a combo box from the control toolbox. It has autocomplete capabilities
and *doesn't* need a VBA interface. You set the autocomplete option in the
Properties.

--
Biff
Microsoft Excel MVP

"DonkeyKong" wrote in message

...
On Dec 29, 9:44 am, Pete_UK wrote:





Use a Combo box - Debra Dalgleish shows how he

http://www.contextures.com/xlDataVal10.html

Hope this helps.

Pete

On Dec 29, 2:00 pm, DonkeyKong wrote:

Okay,

I am stumped here.

I have a data validation drop down as a list format. Since the list
is over 5000 unique entries, I want to be able to start typing the
value and have it start to go there. However, whenever I start to
type the value, it won't let me. I have another list validation on
the same file that does this and cannot figure it out.

Any ideas?

Thanks!- Hide quoted text -

- Show quoted text -

Pete, is there another way to do this? *Because then I need to
reference what is in that cell - similar to a vlookup situation and
don't want to get in to the VB, though I could do it that way - just
wanted to know if it was easier...- Hide quoted text -

- Show quoted text -

I guess I should have read this...

"You can use Data Validation to create a dropdown list of options in a
cell. However, the list font can't be changed, nor can the number of
visible rows, which has a maximum of eight. Also, Data Validation
doesn't have an AutoComplete feature, which finds matching items in
the list as you start to type."

Slams head against the wall...