textsize on comments
 

I want to make the textsize in a comment bigger , but I
can't find any vba code to do this. If it isn't possible
to change the fontsize of a comment in a macro, is there
someway to change the default font and size of a
comment's text?

/Andreas

textsize on comments
 

Its a bit of a long one this...!

ActiveCell.Comment.Shape.TextFrame.Characters.Font .Size =
16

Cheers,
Dave.
-----Original Message-----
I want to make the textsize in a comment bigger , but I
can't find any vba code to do this. If it isn't possible
to change the fontsize of a comment in a macro, is there
someway to change the default font and size of a
comment's text?

/Andreas
.

textsize on comments
 

Big thanks!

/Andreas


-----Original Message-----
Its a bit of a long one this...!

ActiveCell.Comment.Shape.TextFrame.Characters.Fon t.Size
=
16

Cheers,
Dave.
-----Original Message-----
I want to make the textsize in a comment bigger , but I
can't find any vba code to do this. If it isn't
possible
to change the fontsize of a comment in a macro, is
there
someway to change the default font and size of a
comment's text?

/Andreas
.

.