Goto a named cell using Worksheet_BeforeDoubleClick(

**Daniel Brown** · 01-25-2015, 07:29 AM

Hello

I am new to VBA and am wanting to jump to a location on a page when I double-click a cell. It works fine if I give the cell to jump to a range specified directly (click on 5 for section5) but I am trying to jump to section1 when I click on 1 and create the name.

I attach a sample of my workings.

Any tips please.

Regards

**Richard Buttrey** · 01-25-2015, 08:20 AM

Hi,

Have you considered using the normal hyperlink functionality? You don't need VBA

**Daniel Brown** · 01-25-2015, 09:07 AM

Richard

Thank you for the tip.

I have tried this and have a new error. Please see attached.

I think my problem is that I am declaring path as a string and using as a Reference in Goto.

Regards

**Richard Buttrey** · 01-25-2015, 09:16 AM

Hi,

You seem to be missing the point I was making. You don't NEED VBA. You can just use hyperlinks. See attached where I've added the first two for you.

See attached

**Daniel Brown** · 01-25-2015, 10:04 AM

Thanks

Not quite what I want to do. I want to use VBA.

Thanks for the tip though.

Regards

Goto a named cell using Worksheet_BeforeDoubleClick(

LinkBack

Thread Tools

Rate This Thread

Display

Goto a named cell using Worksheet_BeforeDoubleClick(

Re: Goto a named cell using Worksheet_BeforeDoubleClick(

Re: Goto a named cell using Worksheet_BeforeDoubleClick(

Re: Goto a named cell using Worksheet_BeforeDoubleClick(

Re: Goto a named cell using Worksheet_BeforeDoubleClick(

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Sub Worksheet_BeforeDoubleClick

Worksheet_BeforeDoubleClick Not Working

Goto a named range/cell

[SOLVED] Goto a named range using the contents of the active cell

Sub Worksheet_BeforeDoubleClick from elsewhere?

Bookmarks

Bookmarks

Posting Permissions