Font control for cell Notes and Comments

[Roland Hoelscher]

Is there a way that I can control the font which Excel uses when inserting/adding a Note for a cell? This refers to the Note which pops up when I hover the cursor over a cell.
My reason for asking - I have developed an Excel application which incorporates Excel Notes as a key feature of the application and each Note has many lines of text.
On sheets which have many columns a VBA routine inserts a Note for column A in each row. The Note shows the values of all the other columns in the same row. This eliminates the need for horizontal scrolling (which can seem frustrating).
The font which Excel uses by default for these Notes is a proportional font. I would like to use a non-proportional font since that makes it easier to align the text within each Note.
I'm currently inserting various number of spaces to "somewhat" align the different lines within each Note.
Is there a way to control which font is used by Excel when adding these Notes?
Thank you

 

[Skyybot]

Right click to Edit Note. Select Text. Right click to Format Comment. You can format that way. Or, if there are many Notes that you would like to change then you can use VBA.

 

[jkpieterse]

Code to change the font of the comment in cell A1 may look like this:

    With Range("A1").Comment.Shape.OLEFormat.Object.Font
        .Name = "arial"
        .Size = 20
    End With

 

[Roland Hoelscher]

Thank you very much Jan. I will try this out.
Roland