Helper Bubbles and Tooltips in Excel

Learn how to add professional tooltips and popup help messages in Microsoft Excel using both built-in Excel features and Automation with vba/macros.

In this tutorial, I show you two different ways to create tooltips in Excel. First, you'll learn how to create a tooltip that appears when you hover over a shape or image using Excel ScreenTips. Then, you'll learn how to create dynamic popup help windows using one reusable VBA macro automation (that anybody can handle).

The macro automation method is especially useful because you can add multiple shapes or help icons to a worksheet, assign a different message to each one, and still use only a single macro. I also show you how to create multiline popup messages so longer instructions are easier to read.

This is a great technique for Excel dashboards, data-entry forms, templates, interactive workbooks, and any spreadsheet where users may need extra instructions without adding more clutter directly to the worksheet.

Topics Covered:

• How to add a tooltip in Excel
• How to create an Excel tooltip on hover
• How to use Excel ScreenTips
• How to add ScreenTips to shapes and images
• How to create popup help messages in Excel
• How to assign a VBA macro to a shape
• How to pass text arguments from an Excel shape to VBA
• How to use one VBA macro with multiple buttons or shapes
• How to create dynamic VBA popup messages
• How to create multiline MsgBox messages
• How to add help icons and instructions to Excel worksheets
• How to make Excel workbooks more interactive and user-friendly

If you build Excel templates, dashboards, forms, or automated workbooks, these techniques can help you give users instructions exactly where they need them without filling the worksheet with extra text.

If you'd like to learn more about automating Excel, check our Excel Automation Courses.

I hope you enjoy the video! :)

Don