Comment Box Size

[jspizman]

Hello,

I am currently building a dataset with a large number of comment boxes. I would like to resize the comment boxes so they are more viewable (ie, the entire text can be seen). Is there an easy way to do this without individually changing each box (there are thousands of comments).

Thanks for the help,
Josh

[dominicb]

Good evening jspizman

In just the one worksheet or for the whole workbook?

Try this :

Please Login or Register  to view this content.

if you are uncomfortable with macros, then download my add-in via the link below and goto Ultimate > Cells > Comment Tools and find Autosize Cell Comments under the Report/Format tab.

HTH

DominicB

[jspizman]

Thank you. I downloaded your ultimate add-in and it worked very easily.

Thanks again,
Josh