VBA code Auto size for comment box

[danial]

Sawasdee,

any one who help me.
I have a problem about VBA code for re-size of comment box.
I can create code for create comment but I can't to re-size frame of comment to Auto size.

Kindly share.
Tnx in adv.

 

[northwolves]

It's easy.
Suppose you want to do this in cell C5:

Sub Macro1()
    [c5].Comment.Shape.Select True
    Selection.AutoSize = True
End Sub

Best Regards

 

[danial]

It's faild with "Run time error"

I think, should place this code before

[C58].Comment.Visible = True

thanks for your idea to me apply