Hi.

When I insert a cell comment using VBA, is it possible
to make it auto adjust the width and height according to the content?

If one comment consist of let say 10 lines and the longest line is of 45 characters then those values should direct the height and width of the comment...

Any trick to make the size fit the content would be nice.