Cell comments

[pk]

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

 

[Dag Johansen]

[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

 

[pfsardella]

The following discussion deals with this problem.

http://groups.google.com/groups?hl=...selm=u5zbS#[email protected]

HTH
Paul

 

[Tom Ogilvy]

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

--
Regards,
Tom Ogilvy

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

.