I'm not sure what your question is. Is it that you want to know how to get
the "worksheet row here"? If so, try using c5.Row in place of your quote.

--
Rick (MVP - Excel)


"Ayo" wrote in message
...
I have a form with a 2 column listbox, and a worksheet with a two column
list. I want to add items from the worksheet list to the listbox based on
specific conditions. For example:

For Each c5 In dbeWS.Range("B2:B" & rngSAPlines).Cells
If c5.Value = ufrmsiteInfo.cmbSiteID.Text And c5.Offset(0,1).Value
ufrmsiteInfo.txtbox3.Text And c5.Offset(0, 4).Value = False
Then
ufrmsiteInfo.ListBox4.AddItem "worksheet row here"
End If
Next c5