Resizing Comment Box

E

Eager2Learn

I would like to set the size of the comment box I am adding. Here i
the part of the code with the comment:

.Offset(0, 2).AddComment "Reopened: " & Date

this is all in a With statement.

Help, please.
E2
 
B

Bernie Deitrick

E2L,

With .Offset(0, 2).Comment.Shape
.Width = 100
.Height = 200
End With

HTH,
Bernie
MS Excel MVP
 
Top