Thread: Referencing the nth member of a combobox

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.]