Lets say I have 5 items added to a combobox named CBOBOX and these items are Jim, Kelly, Laura, Dave, and Jenny. Is there a way to reference the 1st, 2nd, 3rd, etc members of that combobox.
More specifically what I want to do is run a for next loop that will find run a match function down column A and return the row numbers of the items in my combobox.
Something like this:
Sub ComboRow()
Dim RowNumber as Integer
Dim Name as String
For i = 1 to 5 step 1
Name = Userform1.CBOBOX.[something that references combobox members](i)
RowNumber = application.match(Name, Range("A1:A100"), 0)
[do some calculations with row number]
next i
end sub
Any help is appreciated
[Edit: I found the solution. Userform1.CBOBOX.Column(0,i) is the answer.]
Bookmarks