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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to fill a combo box with choice from another combo box 7
SOLVED! Allow Autocorrect is the culprit when caps lock fouls up AutoExpand in combo boxes 0
Combo Box Question 22
combo box selection issue 2
tab to select combo box instead of field? 7
resetting combo box to top line 1
Combo Box format 0
Auto select when using Combo box in worksheet 2

Back
Top