This should be an easy one.

I have a listbox which houses the address of certain cells (i.e. Sheet1 E39). I would like for the listbox to immediately take the user to the selected cell while remaining open so that said user may quickly hop over to a different cell by selecting it from the list. This should work for scrolling as well (so that if you press "Down" Excel jumps to the address of the next value.

As of now, one has to select the cell, then press enter to go to the cell.

Here's my code for reference (I've also tried Listbox1_Click()) to no avail..

Private Sub ListBox1_Change()
choice = Split(ListBox1.Value, " ")
Sheets(choice(0)).Select
Range(choice(1)).Select

End Sub

Any suggestions?? Thanks!