Ethan
09-05-2011, 12:06 PM
Hello all,
the following code selects the selected corresponding cell from the listbox.
If ListBox1.ListIndex > -1 Then Cells(ListBox1.ListIndex + 1, 13).Select
However the cells are on another sheet than the listbox.
What do I need to do?
the following code selects the selected corresponding cell from the listbox.
If ListBox1.ListIndex > -1 Then Cells(ListBox1.ListIndex + 1, 13).Select
However the cells are on another sheet than the listbox.
What do I need to do?