Auto Expand Combo Box

  • Thread starter Thread starter TimH
  • Start date Start date
T

TimH

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
 
Tim

You can put this code behind your combobox

Private Sub ComboBox1_Change()

Me.ComboBox1.DropDown

End Sub
 
Back
Top