Solved: Select Cooresponding Cell Fron Listbox

[Ethan]

Hello all,

the following code selects the selected corresponding cell from the listbox.
[VBA]If ListBox1.ListIndex > -1 Then Cells(ListBox1.ListIndex + 1, 13).Select[/VBA]

However the cells are on another sheet than the listbox.
What do I need to do?

[JWest]

Try the following:

[VBA]
If ListBox1.ListIndex > -1 Then

Application.Goto ActiveWorkbook.Sheets("Sheet2").Cells(ListBox1.ListIndex + 1, 13)
[/VBA]

Replace "Sheet2" with the location of the cells you wish to select

[Ethan]

Thanks JWest, it worked!