Assuming a listbox from the control toolbox toolbar, you can use the click
event:

Private Sub ListBox1_Click()
If listbox1.ListIndex < -1 then
Range(Listbox1.Value).Select
End If
End Sub

--
Regards,
Tom Ogilvy

"Greg B" wrote in message
...
I have a listbox which I am listing cells a1:a1000 on a worksheet called
"homes". I would like the ability to have the user highlight the item in
the list box and execute a code that will go to that cell.

Is this possible

Thanks

Greg