Cannot autofit the comments

[unley]

I found some code on the net that whenever you double click on the cell, it will automatically insert the comments but what I want it to do is to add another line if the sentence in the comment is getting too long.

This the code I have on the worksheet:

Please Login or Register  to view this content.

Somehow even the code has AutoSize = True, it still does not work.
DoubleClickAddComments.xls
Thanks in advance

[Leith Ross]

Hello unley,

Your code works correctly. The autosize feature sets the comment width equal to the widest line of text entered.

[unley]

Thank for a quick reply.
I thought Autosize stop the sentence at certain length before going to the next line.
So is there any way of altering the codes for certain length in comments?

Like I want twenty letters (including spaces)before going to the next line?