Microsoft Excel Tutorial: Display an in-cell tooltip based on a calculation.<\/p>\n
To download the workbook from today: https:\/\/www.mrexcel.com\/youtube\/Q5vwz18lir4\/<\/a> Welcome to episode 2631 of MrExcel’s netcast! In this video, we will be discussing an amazing idea that was sent in by one of our viewers on YouTube. The idea is to have a cell tool tip that is calculated on the fly, meaning that the recommended value in the tool tip changes based on the data entered. This is a great way to make data entry more efficient and accurate.<\/p>\n In this old video from 2019, I showed how to create a cell tool tip. However, after receiving this suggestion, I knew I had to share it with all of you. So, let’s dive into how to create a cell tool tip that is calculated on the fly. We will be using data validation, specifically the input message feature, to set up a tool tip that appears whenever we enter a specific cell. But, the real magic happens when we add a macro that changes the input message based on the data entered.<\/p>\n Before we get started, make sure your workbook is saved as an XLSM or XLSB file and that your macro security settings are set to allow macros. Then, we will go into the VBA editor and add some code that will run every time we change the selection in the worksheet. This code will check if the selected cell is one of the input cells we specified and if it is, it will delete the current validation and add a new one with a title and message that is calculated based on the data. This means that as soon as we enter the cell, the tool tip will change to display the recommended value. We will also show you how to use this feature for a repeating calculation, such as suggesting a bonus based on a quota. So, make sure to watch the full video to see this amazing tool tip in action. Don’t forget to like, subscribe, and leave a comment down below with any questions or comments. Thank you for watching and we’ll see you in the next episode of MrExcel’s netcast!<\/p>\n Buy Bill Jelen’s latest Excel book: https:\/\/www.mrexcel.com\/products\/latest\/<\/a><\/p>\n
\nRather than type the code, download the workbook and copy it from my workbook.<\/p>\n