Userform listbox - Getting Sheet row of selected item

Hi all

I have a list box with values from rows within a sheet.

Is there anyway of getting the row number of which contained the original data from the sheet data source by selecting the item in the list box?

Any ideas appreciated

Thanks

Let's say your list data is stored in cells B5:B10, so you know up front the row number of the first item in the list box (ie. row 5).
I'm not sure what listbox you're using, but in the forms control, i would calculate the corresponding row as required. So if you select the 3rd item in the listbox:
Start row number + List1.ListIndex, so if you select the 3rd item in the listbox, you'd get 5 + 2 = 7 (ListIndex is base-zero)

Thanks

I have filters in place so this will effect the listbox order to the row order on the worksheet

I can only find a way of getting the value of the listbox row.

I need to look up the row that this would be on the sheet holding the data.

With filters in place this method cant be used