comment box

[brackmeister]

I have searched for the method needed to change the default size of a
comment box.

I know how to change the font and user name and shape of the box.

I also know how to change the size of a comment already entred by
dragging the bars and by increasing the size parameters. But all that I
change does not generate to the new comment box.

I need the comment box to open with a taller and wider box. Can anyone
tell me how to change the default to the size of a new comment box?

John

 

[Gary''s Student]

I don't think there is a way to change the default. You can accomplish the
same thing with:


Sub Macro1()
Selection.AddComment
Selection.Comment.Visible = True
Selection.Comment.Text Text:="Hello World"
Selection.Comment.Shape.Select
Selection.ShapeRange.Width = 150
Selection.ShapeRange.Height = 150
End Sub

Rather than using Insert > Comment

 

[David McRitchie]

Hi John,
There is no specific default size, the size is based on your original use.

Some additional insight.
Resizing All Cell Comments, Resize (#resizing)
http://www.mvps.org/dmcritchie/excel/ccomment.htm#resizing