Just a little further with this one. Am I able to execute a hyperlink using
this method? I have tried it but it comes with the runtime error.

Thanks
Greg
"Greg B" wrote in message
...
Thanks Tom
"Tom Ogilvy" wrote in message
...
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