Cell comments

  • Thread starter Thread starter pk
  • Start date Start date
P

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...
 
[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
 
[A1].Comment.Shape.TextFrame.AutoSize = true

--
Regards,
Tom Ogilvy


pk said:
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...
.
Click to expand...
.
Click to expand...
Click to expand...
 
Back
Top