Go to an item selected in a listbox

[gheyman]

is there a way to go to the item on a spreadsheet automatically by the item you select on a listbox on a user form?

Less say that column A has a list of employee name (no duplicates in the list). When one is selected from the list is there a way to go to the source data spreadsheet and to the row the name is located on?

Help is very much appreciated - Thanks

 

[c_m_s_jr]

Have you looked at the HYPERLINK function? Perhaps link the results from the listbox to a cell then use a HYPERLINK function the user can select which will take them to the source spreadsheet.

 

[gheyman]

Just for clearification, the spreadsheet AKA Tab is in the same excel preadsheet as the userform with the listbox.

 

[c_m_s_jr]

HYPERLINK will still work