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