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

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

Thanks for the reply.

This easy, I know. what I am looking for is to hide the cell address
from the list. It should show only the word GO TO without cell address
and it links to the particular cell address.

Thanks

Put in an additional column with the cell address and hide the column by
making it have zero width.

--
Regards,
Tom Ogilvy


"Soniya" wrote in message
oups.com...
Thanks for the reply.

This easy, I know. what I am looking for is to hide the cell address
from the list. It should show only the word GO TO without cell address
and it links to the particular cell address.

Thanks