MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question
How to change the Excel comments box Font to Caliber, while keying in the comments area (or) focusing out of the comment box with a VBA code.
Below is the code I am using, but I have to run it every time for the font change to update.
Dim cmt As Comment
For Each cmt In ActiveSheet.Comments
.Name = "Calibri"
.Size = 8