find selected combobox item's row

[Bob Phillips]

Maybe try

Set rngCell = Cells.Find(What:=UserForm1.ComboBox1.Value, After:=Cells(1, 1), SearchOrder:=xlByRows, SearchDirection:=xlPrevious)
    If Not rngCell Is Nothing Then
    With rngCell
        strFullAddress = .Address
    End With
Else
    Msgbox "oops!"
End If