Excel ToolTips on Mouse Hover for Buttons and Shapes

Add to Favorites
Author: | Edits: don

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


Downloadable Files: Excel File

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...
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...
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...
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...
Make a Transparent Chart in Excel
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 ...