Microsoft Excel Tutorial: Display an in-cell tooltip based on a calculation.
To download the workbook from today: www.mrexcel.com/youtube/Q5vwz...
Rather than type the code, download the workbook and copy it from my workbook.
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 RU-vid. 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.
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.
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!
Buy Bill Jelen's latest Excel book: www.mrexcel.com/products/latest/
You can help my channel by clicking Like or commenting below: www.mrexcel.com/like-mrexcel-...
Table of Contents
(0:00) Cell Tooltip from a Calculation
(0:20) Adding ToolTip using Validation
(0:40) Tour of the Sample Worksheet
(1:26) Save as XLSM
(1:39) Change Macro Security
(1:51) Open VBA Editor and Find Code Pane
(2:50) How Selection_Change Macro Works
(3:19) The Code to Change Input Message
(3:56) Demo of it Working
(4:52) Alternate code to look to cell to the left
(5:20) Using Intersect in VBA
(5:56) Demo of ToolTip based on cell to left
(6:35) Clicking Like really helps the algorithm
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #excelhacks #walkthrough #evergreen #spreadsheetskills #excelvba #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #exceltooltip
This video answers these common search terms:
what is tooltip in excel
what is a tooltip in excel
how to add tool tips in excel
how to insert tooltip in excel
excel how to create tooltip on cell
excel cell tooltip calculation
custom excel cell tooltip
tool tip based on nearby data
create dynamic tooltip in excel
excel hover over cell for calculation
excel formula-based cell tooltip
display calculated tooltip in excel
tool tip from adjacent cell data in excel
excel data tooltip on hover
excel cell info pop-up
Join the MrExcel Message Board discussion about this video at www.mrexcel.com/board/threads...
14 июл 2024
