how to control the size of a comment

  • Thread starter Thread starter =?iso-2022-jp?B?RVhDRUwbJEIhIRsoQk5FV1M=?=
  • Start date Start date
?

=?iso-2022-jp?B?RVhDRUwbJEIhIRsoQk5FV1M=?=

hi,

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

thanks
 
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
 
Back
Top