Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
Excel ToolTips on Mouse Hover for Buttons and Shapes
Excel trick to add ToolTips to any of your shapes when a user hovers over them in a worksheet, including buttons.
This is a great little trick and I show you how to use it in combination with icons to better describe what buttons do in a worksheet.
Add ToolTips to Selected Shapes in the Worksheet (including buttons)
Sub AddToolTip()
' TeachExcel.com
'
' Select a Shape, run this macro, and input your ToolTip in the popup window.
Dim selectedShapes As Shape
Dim toolTipText As String
toolTipText = InputBox( _
Prompt:="Input a ToolTip for the selected shapes.", _
Title:="ToolTip Input")
For Each selectedShapes In Selection.ShapeRange
ActiveSheet.Hyperlinks.Add _
Anchor:=selectedShapes, _
Address:="", _
ScreenTip:=toolTipText
Next
End Sub
Question? Ask it in our Excel Forum
Similar Content on TeachExcel
Prevent Images and Shapes from Resizing or Moving in Excel
Tutorial: How to stop Images and Shapes from resizing in Excel when you change the size of rows and...
Tutorial: How to stop Images and Shapes from resizing in Excel when you change the size of rows and...
Print Different Headers for Odd and Even Pages in Excel
Tutorial: How to print pages in Excel with different headers for odd and even pages. Steps Go to the...
Tutorial: How to print pages in Excel with different headers for odd and even pages. Steps Go to the...
Filter Data in Excel to Show Rows/Data That Meet Multiple Criteria for One Field - AutoFilter
Macro: This free Excel macro filters data in Excel based on multiple criteria for one field in th...
Macro: This free Excel macro filters data in Excel based on multiple criteria for one field in th...
How to Add Boxes, Buttons, Arrows, Speech-Bubbles, Hearts, and More to a Spreadsheet in Excel
Tutorial: In this tutorial I am going to cover inserting and editing Shapes in an Excel workbook, as...
Tutorial: In this tutorial I am going to cover inserting and editing Shapes in an Excel workbook, as...
Make a Transparent Chart in Excel
Tutorial: How to make a Chart transparent so that it blends in with its background and surroundings...
Tutorial: How to make a Chart transparent so that it blends in with its background and surroundings...
Make Professional Looking Rounded Buttons in Excel
Tutorial: How to make professional looking rounded buttons in Excel. This allows you to avoid using ...
Tutorial: How to make professional looking rounded buttons in Excel. This allows you to avoid using ...