This is a discussion on How to set comment font size and color in VBA within the Excel Questions forums, part of the Question Forums category; Hi, I used record to generate a VBA Macro to set the comment font size and color. When the Macro ...
I used record to generate a VBA Macro to set the comment font size and color. When the Macro was generated, nothing shows up in Macro.
Could you help me to generate a code in VBA to set the comment font size and color?
Thank you very much.
Here is a sample macro that sets the font size, color and name of all comments residing in the selected cell or cells.
Dim Cell As Range
For Each Cell In Selection
If Not Cell.Comment Is Nothing Then
.ColorIndex = 3
.Size = 12
.Name = "Arial Black"
VBAexpert Excel Consulting
LinkedIn Profile http://www.linkedin.com/pub/damon-ostrander/7/79/a93
AllExperts Profile http://www.allexperts.com/ep/1059-30...-Ostrander.htm
(My other life: http://damonostrander.com )