Get row number from table based on listbox selection

[behedwin]

How do i get the table row number based on the selection in a listbox?


I have a listbox that i populate with data from a table.

I want to select a row in the listbox and get that datas row number from the table.
Not the row number of the listbox, but the row from the table where the data is stored.

This problem is really annoying...
Cant figure out how to approach this.

If user select data xxx in listbox, search table1 and return row number of result.
How?

[AlphaFrog]

If you populate the listbox from a range (say "A2:A10" for this example) then you know the first Item in the listbox is in row two. You could then use the index number of the selected item in the listbox to determine the row number.

The listbox index numbers start at zero for the first item and increase by one for each item. This will return the row number of the selected item assuming the listbox is filled from a range starting at row 2.

Please Login or Register  to view this content.

.ListIndex is the index number of the selected item in the listbox.

[behedwin]

If you populate the listbox from a range (say "A2:A10" for this example) then you know the first Item in the listbox is in row two. You could then use the index number of the selected item in the listbox to determine the row number.

The listbox index numbers start at zero for the first item and increase by one for each item. This will return the row number of the selected item assuming the listbox is filled from a range starting at row 2.

Please Login or Register  to view this content.

.ListIndex is the index number of the selected item in the listbox.

I dont tested this, but it wont work.
Thing is that my listbox contain data from a larger table.
I filter out certain things to view in the listbox.
So if i select data1 on row 1 in the listbox. Data1 can be located on row 50 in the table.

I want to know what row the data is in the table. So if i click on data1 on row1 in the listbox, i want to get the row number of where data1 is located in the table.

[AlphaFrog]

Then the way I would do it is when you populate the ListBox with the filtered items, populate another column in the listbox with the row number of each item. Then when you select an item, you can read its row number as well. The column in the listbox that contains the row numbers could be hidden if you don't want to see it. If you need help on how to do this, attach an example workbook and I'll see what i can do.


Alternatively, you can use the .Find method to search for the selected Item e.g.

Please Login or Register  to view this content.