You can certainly precede the address with Goto in the list

Listbox1.Additem "Go to " & cell.Address

then in the click event you can have code like

With Listbox1
sAddr = .list(.listindex,0)
End With
sAddr = Replace(sAddr,"Go to ","")
Appliction.Goto Reference:=Range(sAddr), Scroll:=True

--
Regards,
Tom Ogilvy



"Soniya" wrote in message
oups.com...
Hi All,

Is it possible to make a custom text representing cell address in a
find all like situation?

I am using a user form to find certain text and shows the result in a
list box.

it lists the cell adress and column1, column2 and column3 data in the
list box for all those find items. Instead of the cell adress in by
column1 of list box can I have something like "GO TO" and when i click
GOTO it will got the cell address? same like when we click on the cell
address on the excel find all form, except that I want GO TO instead of
showing the address.

thanks