I'm new to VBA. I'm trying to make an object pointer so I can dynamically populate some ComboBoxes. Here is what doesn't work:

Public Sub showForm()
    UserForm1.Show
    Sheet1.Activate
         
    For i = 1 To 4
        a = "UserForm1.ComboBox" & i
        a.ColumnCount = 1
        a.RowSource = "A2:A11"
    Next i
  
End Sub
I've tryed switching data types with "as object" with no luck. Searching for this on the web is crazy. It seems everyone wants some pointers on using excel.