Hi everybody,
Is it possibile to format the text in comments with VBA? (Excel 2003)
e.g. one word bold or underlined or different sizes like you can do maually.

I will copy text from a worddocument and insert text from wordparagraphs as
comment to different cells.I know that it´s possbile to make line feed in the
comments with VBA.
Another question is if the default format in comments can be changed with VBA.
Thanks in advance for any answers or comments.
Mats
--
ESI Update

http://www.contextures.com/tiptech.html

Look under C for various pages discussion comments, including programming

You can't change the defaults with VBA as comments don't have separate
defaults.

for instance, the background color is the TipText background color defined
in the Windows settings.

--
Regards,
Tom Ogilvy


"Mats Nilsson" wrote in message
...
Hi everybody,
Is it possibile to format the text in comments with VBA? (Excel 2003)
e.g. one word bold or underlined or different sizes like you can do
maually.

I will copy text from a worddocument and insert text from wordparagraphs
as
comment to different cells.I know that it´s possbile to make line feed in
the
comments with VBA.
Another question is if the default format in comments can be changed with
VBA.
Thanks in advance for any answers or comments.
Mats
--
ESI Update

Hi Mats,
You can change some of the default formats, but not the font which is Tachoma.
http://www.mvps.org/dmcritchie/excel/ccomment.htm#font

Don't know how or if you can change formatting of substrings within a cell
comment with VBA -- when I do that while recording a macro , I don't see
any changes for color or font weight.