ComboBox AutoWordSelect issue?

[underpressure]

When debugging, UserForm ComboBox1 and 2 will “auto select” the names in the ranges.
I can enter the first letter in the ComboBox and the item is displayed, in this case, Range R is a list of cities, Range S is a list of States.

When the UserForm is run LIVE, I must enter the entire city or state name even though the ComboBoxes display the lists.

What can I do to resolve this issue?

Private Sub UserForm_Initialize()
Dim x
Dim y
With Sheets("Settings")
    For x = 1 To .Cells(Rows.Count, "R").End(xlUp).Row
        ComboBox1.AddItem (.Range("R" & x).Value)
    Next x
    For y = 1 To .Cells(Rows.Count, "S").End(xlUp).Row
        ComboBox2.AddItem (.Range("S" & y).Value)
    Next y
End With
End Sub

 

[Fluff]

Not sure what your problem is, but you can populate the combos like

Private Sub UserForm_Initialize()
   With Sheets("settings")
      Me.ComboBox1.List = .Range("R2", .Range("R" & Rows.Count).End(xlUp)).Value
      Me.ComboBox2.List = .Range("S2", .Range("S" & Rows.Count).End(xlUp)).Value
   End With
End Sub

rather than looping through the ranges.

 

[underpressure]

Thanks for the tip Fluff.

The combos populate properly.
But, items must be selected from the lists.
I'd like to type the first few letters of the city name and have it automatically select the city...so I don't have to select or type the entire name into the combo.
If "c" is entered into combobox1, Chicago is displayed
if "d" is entered, Detroit is displayed
if "r" is entered, and no city in the list starts with R, then I must enter the entire city name into the combobox.

It works when run from debugging but not when the project is live.

 

[Fluff]

What do you have set for "MatchEntry" in the properties window?

 

[underpressure]

MatchEntry = 1-fmMatchEntryComplete
MatchRequired = False

 

[Fluff]

I cannot replicate your problem, so not sure what is happening.
If I type in an initial letter the combo autofills with the first value in the list that starts with that letter.

 

[underpressure]

Thanks Fluff.
Yeah, it's odd.
I've got several combos that work perfectly.
This one has me "head scratching".

 

[Fluff]

You don't by any chance have spaces before some of the words do you?
Also it may be worth deleting that combobox & then adding a new one, to see if that fixesit.

 

[underpressure]

No spaces found.
Did the delete and add new combos...
Still no workie...except from debug.

 

[Fluff]

Not sure what else to suggest.