Setting margins in comments with VBA

[Bernhardlip]

I need help writing code to set margins within the cell comments themselves in VBA. I have found posts to set every other kind of margins, but not in cell comments. let me know if you know of any.

For Each MyComments In ActiveSheet.Comments
With MyComments
.Shape.AutoShapeType = msoShapeRectangle
.Shape.TextFrame.AutoSize = True
.set cell comment margin right, left, top, bottom. ????

 

[Fluff]

Try

.Shape.TextFrame.MarginTop = 5
.Shape.TextFrame.MarginLeft = 20