Setting a comment box default size and font

[Sam2149]

Hi can I please ask a question on Excel 2010 VBA

I have looked at the following

http://www.excelforum.com/excel-gene...-box-size.html

I think I understand it at least I can get it to work.

My question is can this code be adapted to set the default font and text size at the same time as setting the comment box size

Regards

[HaHoBe]

Hi, Sam2149,

maybe like this:

Please Login or Register  to view this content.

Ciao,
Holger

[Sam2149]

Hi HaHoBe, thank you for the advice you have given me

I must be doing something wrong when I run the macro it changes the comment box size but the text remains the same the default text is (Tahoma size 9) and does not change to (Courier) as in your code.

I'm sure it must be me but have you any idea what I am doing wrong

Regards

[HaHoBe]

Hi, Sam2149,

instead of

Please Login or Register  to view this content.

it should read

Please Login or Register  to view this content.

Ciao,
Holger

[Sam2149]

Brilliant thank you so much