how to control the size of a comment

E

EXCEL$B!!(BNEWS

hi,

i wonder how to control the size of a comment i added in a cell with vba.
i failed all,

thanks
 
W

Wm Seales

For an individual comment, this is one possibility:

With ActiveCell.Comment
.Shape.Width = 200
.Shape.Height = 100
End With

For all comments on a sheet:

Dim c As Comment

For Each c In ActiveSheet.Comments
c.Shape.Width = 200
c.Shape.Height = 100
Next

William
 
Top