View original (French)

The comment opens far from the associated box

Solved
marseille stl Posted messages 8 Status Member -  
eriiic Posted messages 24581 Registration date   Status Contributor 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 answers

  1.
    eriiic Posted messages 24581 Registration date   Status Contributor 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
    1. marseille stl Posted messages 8 Status Member
       
      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
    2. marseille stl Posted messages 8 Status Member
       
      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