Excel "BeforeDoubleClick" coding advice needed

Hello! I am new to the forum and am constructing a large multi-sheet workbook for personal use. I and am using simple macros to help with page navigation. On one sheet I want to double click on a single cell in a range of cells and have the corresponding individual macros take me to the corresponding worksheets. I know how to construct simple macros and developed simple code that takes me to a single worksheet but I would like to expand the code statement to take me to different worksheets depending on the cell I double click on. The cells I will click on are are all in one column on one sheet. Thanks in advance for your help.

Here is what I have that works;

Please Login or Register  to view this content.

Steve

Welcome.

Please take the time to read up on the forum rules.




Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Hi Steve and welcome to the forum,

See the attached for what I think you want. Double click on any sheet name and it will take you there. Look at the VBA behind the sheets and behind the module to see the code.

VBA Double Click GoToSheet.xlsm

I have a few versions of this.

Give this a try.

Hey Steve,

If your list is in B6 to B45 you need to change the line of:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

You will need to do this on the code behind each sheet.

OK Steve,

It's time to attach your workbook so I can see what you've done.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.