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...

[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...
.

The following discussion deals with this problem.

http://groups.google.com/groups?hl=e... icrosoft.com

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------
On Mon, 22 Sep 2003 10:59:12 -0700, "pk" wrote:

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...

[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...
.

.