Auto Expand Combo Box

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
 
D

Dick Kusleika

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

SOLVED! Allow Autocorrect is the culprit when caps lock fouls up AutoExpand in combo boxes 0
combo box selection issue 2
Populate list or combo box from closed workbook 4
Combo Box Auto expand List Width 4
tab to select combo box instead of field? 7
Extract Outlook Contacts to Combo Box in Worksheet 0
Combo Box and smart key selection 0
Auto tab/combo box 1

Top