Auto resize comment box in excel 2013

[Sam2149]

Hi I have a excel 2013 spreadsheet with quite a lot of comment boxes, if I change the content of the comment boxes to keep it neat I have to resize each comment box individually

Is there a way I can have the comment box auto resize depending on the box content IE if I add more text can I make the box larger to show the extra text automatically

Regards

[CK76]

To my knowledge, it requires VBA to mass adjust comment box size.

Refer to the link for collection of comment box related codes (specifically Resize comments section).
http://www.contextures.com/xlcomments03.html