Dynamic Tooltip

[JPMUAE]

Dear all,
I have an excel file containing the sales for each employee on a monthly basis.
I would like to have a tooltip that shows the name, month and sales when I click on a specific cell.
the tooltip should only be valid for the area where a sale is specified.
I hope someone can help me.
Best regards

 

[vletm]

JPMUAE
Something like this as You've written ...

 

[JPMUAE]

Vletm, your answer is just perfect. You really are a Ninja
Thanks a lot for your quick action.

 

[JPMUAE]

Vletm, do you know if it is possible to increase the size of the font in the tooltip?
Thanks

 

[vletm]

JPMUAE
You could test Yourself ...
How to change the default font size for Excel comments

 

[JPMUAE]

Hi vletm.
this link is not working. I googled a possible way to do it but it says that I need to change the windows settings. that could be annoying as I would need to do it on every PC we are using . I thought there would be a way to do it just when using the excel file.
Best regards

 

[vletm]

JPMUAE
I did not tested that link or any other possible link which seems to have same way to 'solve' that.
Did You mention before that You'll use 'something' with many PCs? ... many so call minor details could change many things upside down.
You asked about using Tooltip
... almost same thing could get by using eg MsgBox or with Statusbar.
You can test three samples one-by-one by selecting cell A1 (ToolTip/MsgBox/Statusbar)