[A1].Comment.Shape.TextFrame.AutoSize = true

--
Regards,
Tom Ogilvy


pk wrote in message
...
I can already do this!
What I need is code to "AUTO SIZE" the comment after it is
created...any ideas on that?

-----Original Message-----
[A1].Comments.Add Hidden:=True "My comment"

will display just the comment indicator on the cell, and
pop up the comment like a hint when moving the mouse
pointer over the indicator.

Regards,

Dag :) -- DagOystein.Johansen AT sage.com


-----Original Message-----
Hello, I hope somone can help me out.

I am using VBA in Excel XP with Windows 2000.

I have some VBA that adds a cell comment:

[A1].AddComment MyText

Now, I would like to "AutoSize" the comment. Everything
I
have tried has failed. I want to leave the comment so
that
only the cell indicator is visible.

Your example code to create a cell comment, "AutoSize"
it,
and close it, would be most appreciated. Thanks in
advance...
.

.