Populate Combox Options from 1st column of multi column Range
I have a dynamic range - myRange, which has 3 columns. my issue is ...how can i get me combobox1 to populate fields from ONLY the first column of the myRange? I am using index to try to grab the first column but its not working....
Private Sub UserForm_Initialize()
ComboBox1.Value = ""
Dim Rng As Range
Dim Cel As Range
Set Rng = (Index(myRange, , 1))
For Each Cel In Rng