Resize Comment

**hylw** · 07-01-2005, 01:58 AM

Hi,

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

**Bob Phillips** · 07-01-2005, 02:12 AM

Originally Posted by hylw

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** · 07-01-2005, 03:10 AM

Hi ,

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

**Bob Phillips** · 07-01-2005, 04:01 AM

Originally Posted by hylw

Hi ,

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

Like this

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

**hylw** · 07-01-2005, 04:16 AM

Thanks for helping, xld.

Have a nice day!

Thread: Resize Comment