Table of Contents Hover Buttons

[pzamory]

I have scoured You Tube, etc. and can't find a decent, easy-to-follow, tutorial on how to create nice looking hover buttons for the main page of my spreadsheet. I would like to simply have users click on a button that takes them to another tab in the worksheet. If anyone knows of a useful tutorial, please pass it along. I'd be very grateful. Thanks

 

[ExcelToDAX]

This was my favorite example for creating modern looking hover buttons.

How To Build A Modern-Looking VBA Userform

The default formats of Userforms have not been updated since the 1990’s and it is very unfortunate since UI design has changed quite a bit since then! In this article, I am going to walk you through how to transform those outdated grey userforms into fresh and current dialogs. Enjoy!

www.thespreadsheetguru.com

 

[Umma123]

First, go to 'Insert' and choose 'Shapes' to create a button. Then, right-click the shape, select 'Assign Macro', and write a quick VBA script like Sheets("Sheet2").Select to link it to another tab. You can customize the button's look by right-clicking again, selecting 'Format Shape', and changing the color, adding effects, or setting a different color for when the mouse hovers. Excel doesn’t natively support hover effects, but using VBA, you can create simple interactions. Hope this helps!

 

[pzamory]

Thanks but I'm not a VBA expert. I'll keep looking though.

 

[Umma123]

Then you should try SkySuite AI. It has a built-in AI assistant for Excel, and I'm sure it can solve your problem.