Default font/Size in Comments Box

[Paul Calcagno]

I'm running MS Office 2007 on a Vista Home Premium OS SP2, all WU's current,
with 2 GB of RAM. Windows defender, Spyware Doctor, MBAM, SAS. Everything's
running just fine.

I'd like to know if there's an easy way to format my Comments boxes (right
click and select `insert comment') so that the default is not bold text with
a font size of 9. I'd like to be able to set the default font to something
else and the default font size to Arial. Is this possible for a hack like
me?

Thanks in advance...........Paul C.

 

[Dave Peterson]

You could use a macro like the one from Debra Dalgleish's site:
http://www.contextures.com/xlcomments03.html#Plain

 

[Paul Calcagno]

Dave, unfortunately I have no idea of how to use the suggestions in the link
you sent me. I've never done any coding in Excel and don't know where to
start. I did find that if I right click on a workbook there's something
called `view code' which brings up a screen where I presume I can enter
something but that's where my knowledge ends.
Paul C.

 

[Dave Peterson]

Since you're new to macros:

Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)