Display comments in specific range of cells

Hello everyone
In my attachment I have merged range ("D7:H21") and In column A I have some cells which have comments ..
All what I need to do is to display the comments to the merged range ..
I have this code in worksheet selection change

Please Login or Register  to view this content.

But first I have to select the cell so as to show the comment in the target merged range
second when roll over the cell which has comment , the comment appears next to it so the comment appears twice (once when roll over the cell and after selecting the cell the comment appears in the target merged range)
Third I need to resize the displayed comment so as to fit the target merged range
Finally if possible I need to execute that without the need of selecting cell .. if possible just when roll over the cell ..

Hope it is clear
Thanks advanced for any help

Any help with this topic?

Is everything clear ..is it possible or not?

still no reply ..is it impossible??!! Just any reply

this was rather painful to find information about

its not exactly how you wanted it with the merged cell but see if this works for you instead

Thank you very much for this gift..it's fantastic ..
Just two remaining points :
Point 1 to get rid of the original comment appeared when roll over the cells ..
Point 2 to do the task using the roll over cells method ..
Thanks a lot for this great help

Still waiting for any new ideas

point 1 you can toggle the comment visible

point 2 is a completely different ball game and you would need to rethink the design
if you google mouseover macro vba you will get some ideas on where to head
i wouldnt want to start anything on it until you are sure you want to head down that road as it is rather extensive to setup

have a google around on what exactly you want to do with it

Thanks for reply again
as for toggling the comment visible ..it shows the comment itself to be seen on the sheet if show & hide the comment if we select hide but this is not a solution for that point .. I need t get rid of the default comment in my issue (that's even if we roll over the cell by mouse just the chart to appear with the comment but not the cell)
Hope it is clear

OK thanks I got point 1 and I used this line to hide comments completely

Please Login or Register  to view this content.

Can you help me in point 2,please?

did you take my advice in researching the solutions?

http://optionexplicitvba.blogspot.co...-in-excel.html
http://www.mrexcel.com/forum/excel-q...ouse-over.html
https://www.atlaspm.com/toms-tutoria...o-run-a-macro/

3 very different ways of tackling the problem all require 3 different ways of setting up

i profess i looked at the first one it looks great and probably something you may want to do ....but i have no idea how it works in the back end and i dont want to spend so much time deconstructing it

i had a play around with the 3rd one i think it looks promising however you need to restrict the view and i dont know if this is OK with your file

i used the second option and applied to your sheet

i think it does what you want it to