Tim

You can put this code behind your combobox

Private Sub ComboBox1_Change()

Me.ComboBox1.DropDown

End Sub


--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"TimH" wrote in message
...
In Access, there is a property behind combo boxes
called "Auto Expand". When I click into the combo box,
and begin to type a letter, then the combo box
automatically goes to the first word in the combo box
that starts with that letter. As I type more of word,
the combo box intelligently locates the choice I am
looking for without ever scrolling through the choices.
Is this possible in Excel 2000, and if so, via VB and how?

Thanks,
Tim