VB Code For Taking a user to a named cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brady Finney - 10 Oct 2006 16:48 GMT

Hi,

I have a long table of contents for a large excel model. I'd like to have a
button next to certain items, that when the user clicks the button, Excel
will take the user to that named Cell. Can anyone tell me what VB code
would go in a command button to allow me to do this?

Any help would be huge, thank you.

Brady

Reply to this Message

Earl Kiosterud - 10 Oct 2006 17:07 GMT

Brady,

You can do this using Insert - Hyperlink. Place in this document. No code
required for this solution.

Signature

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------

> Hi,
>
[quoted text clipped - 7 lines]
>
> Brady

Reply to this Message

Don Guillett - 10 Oct 2006 17:45 GMT

Sub gotonamedcell()
Application.Goto Range("namedcell")
End Sub

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> Hi,
>
[quoted text clipped - 7 lines]
>
> Brady

Reply to this Message