Row reference in a listbox

[Aaron Bean]

Does anyone know how to create a hidden column in a listbox that has the worksheet row number in relating to list item. I have a search function that returns a list depending on what the user has entered but I now need to be able to select the item in the list and go to the row in the spreadsheet from where it came from. Any ideas?

[Ecniv]

In the listbox, there should be a column count - set this to 2 or more.
There should also be a columnwidths property. set this to 0;1 (you can change the size later on).
Then add your data (possibly via .list or .column)
The first column should be invisible (so you can put your Row number/ID in there) and the other column(s) should be visible.
On the on_click event you can get the row number from the hidden column and populate the form.

[Aaron Bean]

Thanks for that, do you know how I put the row number/ID in the hidden column?