Cell Address

[Soniya]

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

[Tom Ogilvy]

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>

[Soniya]

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

[Tom Ogilvy]

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

--
Regards,
Tom Ogilvy


"Soniya" <[email protected]> wrote in message
news:[email protected]...
> 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
>