Appearance of the Comment Position remaining same even after changing it using VBA.

[e4excel]

Dear Forum,

I am adding comments dynamically to a particular column and all of these comments are made visible false by default..
As there will be large amount of Text in these comments in the future..It will be cumbersome to view it in the same screen as I have frozen my screen from the 10th Row on wards and the the Comments would start appearing from the 11th Row..

Now I used a small code which i had got in the forum which works to change the position of the comment..
But this works only when the comments is made visible true...which I dont want ..

Please Login or Register  to view this content.

In the visible false status when we hover the cell it appears at the regular position..

So it normal or something can be done about it..?

Thanks in advance..

Warm Regards
e4excel

[e4excel]

Basically, what I meant is that when I do the Show Comments and then view the comment it appears in the Changed Position moving to the extent of the mentioned in the above code however if i select the cell then the default comment appearance remains in the same position..

[e4excel]

Can someone please confirm whether the Comments only change their position in the Active State and remain at the same position i.e. Un-latered position in their Regular Visible State..

WHen I am doing Show Comments they change the position but when I dont do that they just show close to the cell..cant it be altered to also display them in the Visible State when the cell is selected and not only on SHow COmments..

Thanks in advance

[e4excel]

Dear Forum,

I have not got any confirmation from anyone but I deduce that the Comment position thus would only change when the Comment isin the Show Comment Mode..If that's not true please explain as to why then its not happening only on selecting the cell or simply hovering the cell..

My take is then in that case to select the cell and then Fire the Call ResetComments Macro..However when I tried that in the WorkSheet_SelectionChange Event then all the cells remain in the Show Visible Mode whereas I need it be applicable for only the Target cell..

Please Login or Register  to view this content.

Now I have resorted to using this event so that i can first make the Comment Visible and then be able to have the REset Comments but now the other problem is that all the cells selected in the column remain visible even when they are not selected so how do I overcome this?

Thanks in Advance

[e4excel]

Please Login or Register  to view this content.

Thnaks God It worked so bascially I just needed to know about the Target.Count and the Application.DisplayCommentIndicator Property..

Thanks..

e4excel