Hover Function in Excel Similar to PowerBI

Lali2023

New Member
Joined
Nov 29, 2023
Messages
11
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Hello,
There is a feature in Power BI that I wanted to see if it exists in Excel.

There are a lists of assignments that when the user hovers over the number, the description of the assignment appears. It may be one or two sentences.

I have been researching to see if there is an equivalent like that in Excel; the closest I have come across is a comment or a note. The user should ideally click the comment and see the description.

The only way I could think to achieve this would be to add a comment in every cell with the specific description.

My question is if there is a VBA function that can create a comment in the cell or a note that takes the description from one sheet and is able to match it in the cells in other worksheet where that assignment number appears?

Even though it would be time-consuming, the most direct route would be to create the comment and copy and paste into the cell. Thank you.
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Forum statistics

Threads
1,224,815
Messages
6,181,136
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top