hyperlink - VBA - linking worksheets

[jcorbin69993]

Hi,

I'm no developer/programmer/coder/etc., just a guy with an app idea, and I'm going to use excel to create an example of the idea for pitching purposes. It's very simple. 3 pages (plus hidden data pages) are needed to create the example and all I need to do is find out how to link the 3 pages together using drop down lists and command buttons.

My pages are as follows.

Sheet 1
Sheet 1 Data
Sheet 2
Sheet 3

Sheet 1 has a drop down list that accesses data from Sheet 1 Data. When a user selects an option from that list I'd like it to activate Sheet 2.

Sheet 2 then would need a command button to go back and activate Sheet 1. I have a standard Hyperlink in a cell to go to Sheet 3

Sheet 3 also needs a command button which activates Sheet 2.

Any help would be greatly appreciated.
Thanks in advance.




Sent from my iPhone using Tapatalk

[davesexcel]

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[jcorbin69993]

Hi, thanks for your response.

I've attached an example. I've achieved most of what i need with hyperlinks within cells.

All I need to achieve now is hyperlinking from Sheet 1 to Sheet 2 when a selection from the drop down list is made. All selections will goto the same place. A macro that detects a change and then activates sheet 2 is all I need.

Your help is appreciated.



AppExample.xlsm