Change Sheet Reference Using Rollover Technique in Excel

[manishc1989]

I've created a dashboard which consist of five different sheets. Currently each sheet contains hyperlink formula on which user clicks and move to the desired sheet.

I want instead of clicking on each cell user just hover their mouse on the cell location and it points to the selected location or sheet reference. I tried the below method but it didn't work properly.

Vba Code:

<code style="border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 13px; font-style: normal; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; font-stretch: normal; line-height: normal;">Public Function Onselect()</code>
<code style="border: 0px; font-family: Monaco, Consolas, 'Andale Mono', 'DejaVu Sans Mono', monospace; font-size: 13px; font-style: normal; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; font-stretch: normal; line-height: normal;"> </code>Sheets(2).Range("A2").Select


End Function

Excel Hyperlink Formula:

=IFERROR(HYPERLINK(Onselect(),"Click Here"),"Click Here")

 

[StephenCrump]

You can use the mouse rollover/function technique to change a value in another sheet, but as far as I know you can't make Excel go to the other sheet.

I suggest this might be a good thing? If was the user, I wouldn't want to be jumping to another sheet every time I accidentally dragged my cursor over a hyperlink.