Formatting pop up Comments

[AlexanderBB]

How does one globally set Comments to a font, font size, autoshape type and autosize?

I can do this in VBA but it'd be a lot quicker if it was the default.

Thanks

 

[Logit]

Format worksheet comments - Microsoft Support

 

[AlexanderBB]

Is there anything there about autosize and autoshape? Can't see it.

 

[Logit]

Here is autosize : VBA code to automatically resize cell comment

Sub FitComments()
Dim Rng As Range
Dim Cell As Range
Set Rng = Selection
For Each Cell In Rng
    If Not Cell.Comment Is Nothing Then
    Cell.Comment.Shape.TextFrame.AutoSize = True
    End If
Next
End Sub

And autoshape : You can set the desired shape from the beginning of your project. This resource explains the steps : How to add comments in Excel, show/hide comments, insert pictures
Once on that url page, scroll down about half way to : CHANGE COMMENT SHAPE.