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

Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Excel VBA Course

(35% Sale Ends Jan. 26)

Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course (35% Discount)

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...
UserForm Properties List and Explanation
Tutorial: This is a listing of all properties for the UserForm in Excel. Each property includes an e...
Make a Transparent Chart in Excel
Tutorial: How to make a Chart transparent so that it blends in with its background and surroundings...
Tutorial Details
Downloadable Files: Excel File
Excel VBA Course

(35% Sale Ends Jan. 26)

Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course (35% Discount)