galileogali
Well-known Member
- Joined
- Oct 14, 2005
- Messages
- 748
With this code add comment in a cell.
The text have variable length. Is there a way to set: Comment.Shape.Height and Width, consistent with the length of the string? Is there a par Autosize method the Shape?
Code:
Sub crearComment()
With ActiveCell
.AddComment convertir_cadena(Range("TablaDocumentos"))
With .Comment.Shape
.Height = 354
.Width = 116.25
End With
.Comment.Visible = True
End With
End Sub
The text have variable length. Is there a way to set: Comment.Shape.Height and Width, consistent with the length of the string? Is there a par Autosize method the Shape?