Resize Comment

[hylw]

Hi, :hi:

i would like to resize the comments via coding, can anybody help me with this please? Thanks a lot.

[Bob Phillips]

Hi, :hi:

i would like to resize the comments via coding, can anybody help me with this please? Thanks a lot.

You can do it manually by just going inm to Edit Comment and then clicking on one of the box handles and dragging it.

[hylw]

Hi ,

Thanks for reply. But Is it possible to do by coding? if anyone know please advise. Thanks.:friends:

[Bob Phillips]

Hi ,

Thanks for reply. But Is it possible to do by coding? if anyone know please advise. Thanks.:friends:

Like this



Dim cmt As Comment
Set cmt = Range("F4").Comment
With cmt
.Shape.Width = 200
.Shape.Height = 100
End With

[hylw]

Thanks for helping, xld. :cool: Have a nice day!