Mouse roll over View

Hi there,

Need help in one of the complex file where we have number of Heads present month wise and designation wise. Synopsis is created in front for all these users. Now requirement is that we have numbers in synopsis..

i.e. Jan - 2 Headcounts, Feb - 4 Headcounts. Once I click on these numbers or roll over the mouse, it should show the names on screen (Like screen tip).

I have attached sample file please help.

Thank you.

Hi there,

Thanks for your time. Both the solutions work on this file however this does not work in big file of mine. I have slightly changed the file spread as it does not work on this my file. It gives blank result.

I tried putting exact column size here and rows are 600 + in sheet2 ( in actual file).

Can you please help me.. Many thanks for your swift response earlier. Hope to receive help at the earliest ( appreciate your quick help earlier and apologies for asking help again as it does not work on my file, probably need some help on coding).

Thanks

It is not working .. It shows blank msgbox only... I changed the range as well like ("D4:F9").

Hey sorry to ping again.. macro worked for me of double click.. I was trying to check the macro with just a click (shapes) , it does not work. Can you please suggest the approach here.