Rather than :
VB Code:
Me.Controls("cboRM" & i).RowSource = "'Data Source'!P3:P4"
.. I am using
VB Code:
Sheets("Branches").Activate Range("A2").Select Range(Selection, Selection.End(xlDown)).Select
.. to select my range, but how do I assign it as the Rowsource of my combobox ?
Any takers ?




Reply With Quote