Hello,

I am trying to do something similar with a userform. I have 30 comboboxes that all will have the same options to
pick from so I would like to fill them with a loop. I also, if possible would like the range to be able to change if I have the list expand from user input. If both are not possible I can make it work without the dynamic list.
Right now this is what I have:

All of the comboboxes names start as "PMEmployeePT" and then a number.

The error I get is: Could not set the list property. Invalid property array index (I also get similar things if I try rowsource)

Sub PM_Systems_Loadcombos()

Worksheets("Employees").Activate

For i = 1 To fsrform.PMEmployees.Value
Dim EmployeeTitle
EmployeeTitle = Worksheets("Employees").Range("a3:a" & Rows.count).End(xlUp).Row
fsrform.Controls("PMEmployeePT" & i).List = EmployeeTitle
Next

End Sub