Control Comboboxes Skip to letter

G

GeminiRLP

I have a control combobox. It is populated with data and
it shows up if I click the down arrow of the box. Once I
click the down arrow, I can type a letter and it will
automatically go to the word in the list that starts with
that letter.

Here is my problem: I don't want to have to click the down
arrow of the box to see the list before I type the letter.

I would like to tab to the box, type the letter, have the
appropriate word fill the box, and then be able to tab
again to get to the next cell in the next column.

Is this possible? Thanks in advance.
 
J

jeff

Hi,

I think you can do what you need with the following
code: assume your control combobox "covers" cell
J9. When you tab/select J9, Worksheet_SelectionChange
activates the combobox. then when its value changes,
it selects cell j9 - you can tab away from there.

hope this helps.
jeff

Private Sub ComboBox1_Change()
Range("J9").Select
End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As
Range)
If Target.Address = ("$J$9") Then ComboBox1.Activate
End Sub
 
G

GeminiRLP

Sadly,I'm not good with code. I tried it and substituted
as necessary but I got errors.

My listfillrange is A1:A9
My linkedcell is A22
MatchedEntry is Complete
MatchRequired is False
AutoWordSelect is True

When I tab to the combobox, use the dropdown to see the
list, type the letter and get the item to fill the box -
this works.

The same problem as before exists (have to see the list
first before typing a letter). Also, before, if I tabbed
to the combo box and then typed a letter without first
seeing the list, only the letter I typed would appear in
the box plus the down arrow disappears.

I really appeciate your help.
 
Top