View original (French)

The comment opens far from the associated box

Solved
marseille stl Posted messages 8 Status Membre -  
eriiic Posted messages 24581 Registration date   Status Contributeur Last intervention   -
Hello,

here is my problem:
when I click "edit comment" on my Excel sheet, it opens very far from the cell it is associated with.
I would like to know if there is a way to have the comment stick to its cell when I open it. (It's quite annoying to have to move them manually every time)
thank you

Configuration: Windows 7 / Firefox 19.0

3 réponses

Réponse 1 / 3
eriiic Posted messages 24581 Registration date   Status Contributeur Last intervention   7 281
 
Hello,

to run on the relevant sheets by activating them first: 
Sub posComment() Dim com As Comment For Each com In ActiveSheet.Comments com.Shape.Left = Range(com.Parent.Address).Offset(0, 1).Left + 10 com.Shape.Top = Range(com.Parent.Address).Offset(0, 1).Top + 5 Next com End Sub

You can adjust the +10 (to the right) and the +5 (down).
eric

--
You should never reply to an unsolicited PM...
Well, that’s done.
2
marseille stl Posted messages 8 Status Membre
 
Thank you for your response, eriiic.
I saw on another page of the forum that you have already helped someone with the same problem (I could have looked more, sorry...)
However, I don't have a handle on macros at all. How do I go about making this manipulation?
I would also like to ask you if it is possible to customize comments with this macro system? For example, if I click "insert a comment", I want a blank comment to open, and I would like that when it opens, my template form that I edited by copying and pasting is already there.

Thank you
0
marseille stl Posted messages 8 Status Membre
 
It's all good, I searched how to insert macros and I succeeded.
Eriiic, thank you so much, you really helped us a lot with this!
0