David:

I hate to post just to say thank you, but I've been looking for an answer to
this question for ages. I wish it was in the Excel help info.

Thanks for the help!

"David McRitchie" wrote:

Cell Comments
Changing Font etc in cell comments (#font)
Excel uses the Tahoma font for new comment boxes, and you cannot change
that default. You can set the default interior color, the font color, and the fontsize
in the Control Panel (Display, Appearance, Tool Tip)"
http://www.mvps.org/dmcritchie/excel/ccomment.htm#font

You can run macros (also found in the above page) to change what you have.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"TheN" wrote in message ...
Can anybody tell me how to change the default font and size of a "Comment"?

I can change the font and size of every comment separately but I can't find
a function to set a standard (default).