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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks