[VBA] Populating ComboBox via RowSource -- no scroll bar?

[Zetor]

'Eyall,

I'm trying to use two ComboBoxes for one piece of data to "refine" data entry, as it were. Basically, the user has to choose the county where the event took place in ComboBox1, and then choose the appropriate small area code (NUTS if any of you are familiar with EU conventions ) from ComboBox2. Something like this: (paraphrased)

Private Sub cobBalesetMegye_Change()
    Select Case cobBalesetMegye.Value
        Case "01"
            cobNUTS.RowSource = "Kódtáblák!BV2:BX2"
        Case "02"
            cobNUTS.RowSource = "Kódtáblák!BY2:CA302"
...
    End Select
End Sub

This does populate the second ComboBox correctly, but there appears to be no scroll bar present. I checked the attributes of cobNUTS, it's similar to the other ComboBoxes in the UserForm, and all of those get a scroll bar. With over 400 possible NUTS code choices in some counties, not having a scroll bar is a pain... is there any way to fix this? Or do I have to resort to adding the data manually with AddItem?


TIA,

-- Z.

 

[Juan Pablo González]

You can use

cobNUTS.List = Range("Kódtáblák!BV2:BX2").Value

which I think is much better anyway...

 

[Zetor]

Thanks, looks like it works now... though it looks like the problem was me forgetting to set the ListRows property, d'oh!


-- Z.
feeling like a doofus