Back Button Link

bruntonomo

New Member
Joined
Jul 29, 2018
Messages
48
My question has two parts to it, but I would be happy if I could just get the first part answered. The second part is mostly aesthetics.

1) Is it possible to create a link that will jump back to a previous point in an Excel document? I have a rather large document that I'm creating, and I'm creating reference links to other parts of the document. It would be a huge pain for the user to click the link, jump way down the page, and then have no way of jumping right back to where they were. Is there a way to make a link that 'understands' where you came from and allows you to jump right back?

2) Is there any way to create a floating back button that appears in the bottom right corner once an anchor link is clicked, and then disappears after the user clicks the hover button?
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

bobsan42

Well-known Member
Joined
Jul 14, 2010
Messages
1,343
1) I guess it is - Worksheet_FollowHyperlink Event can be used to determine which link was clicked and make the necessary arrangements/changes at the destination point to allow going back to this cell.

2) I would do this with a small userform (as big as the button on it). Also it should not be modal. Then again Worksheet_FollowHyperlink Event can be used to show the form.
 
Last edited:

bruntonomo

New Member
Joined
Jul 29, 2018
Messages
48
Thank you for the response!

I will have to look at how these events work. I really don't know much of anything about VBA. It gives me hope that I can configure something like this though.

Do you have any suggestions for tutorials that I can follow to learn this?
 

bobsan42

Well-known Member
Joined
Jul 14, 2010
Messages
1,343
I personally started with a "Step by step" book for Access, but this was some long time ago :)
Then filling in the blanks searching through the web. I am not e real developer or programmer - just an enthusiast with not enough spare time recently.
Good luck.
Do not hesitate to use this board to get help.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,969
Messages
5,525,961
Members
409,673
Latest member
Riseee

This Week's Hot Topics

Top