Sheldon, have a look here for some ideas
http://www.contextures.com/xlcomments03.html#Resize
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

"Sheldon" wrote in message
...
In code, I have managed to create a comment, make it visible and add the
text. But How do I, in code, make the comment box large enough to display
the entire text? Now when I hover over the cell which contains the
comment,
only part of the text is visible.


Thanks