Excel Drop-Down Lists

[CCHall]

I'm working with drop-down lists in Excel. I'd like for people who use the spreadsheet to be able to jump through the list by pressing the first letter of the word they want. I thought this should happen automatically, but it doesn't seem to work. I'm using MS Office 2003. Any help would be greatly appreciated.

--CC Hall

 

[SkipVought]

Hi,

What kind of control are you using -- Validation, MS Form or Control Toolbox?

Skip,
[sub]
[red][/red]
[/sub]

 

[CCHall]

I'm using Validation. Thanks.

 

[SkipVought]

That only works in a Validation when there's already data in the column.

Take a look a the Control Toolbox Combobox - MatchEntry property.


Skip,
[sub]
[red][/red]
[/sub]

 

[CCHall]

Thanks, but I don't think that will work for me. I need there to be entries in the columns to use autofilters.

--CC Hall

 

[luceze]

Hi CC,

If you enter the letter first, then click the dropdown, the validation list will scroll to the first entry that starts with that letter.

HTH,
Eric

 

[SkipVought]

It's possible to do that with VBA Code using ONE ComboBox that will behave similar to the validation list.

If you want to pursue this option, please post in VBA Visual Basic for Applications (Microsoft) forum707.

Skip,
[sub]
[red][/red]
[/sub]

 

[CCHall]

Eric,

Thanks, but if I hit a letter first and then click the drop down, I get an error message that says "the value you entered is not valid."

If I click the drop down arrow first, then hit a letter, it does nothing.

--CC Hall

 

[SkipVought]

You're going to have to figure out the behavior of the control with various settings, and if it meets your requirements.

Also which control EVENT is your code in? It can make a difference.

Skip,
[sub]
[red][/red]
[/sub]