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


Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

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...
UserForm Properties List and Explanation
Tutorial: This is a listing of all properties for the UserForm in Excel. Each property includes an e...
Tutorial Details
Downloadable Files: Excel File
Similar Content
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...
Excel Forum