Font formatting inside a comment box 1

[AcousticalConsultant]

Hello,

I was wondering if anyone knew how to format text (e.g. make bold) within a comment box in Excel using VBA. I want to make certain portions of the text bold.

It's easy to do manually, but with the "Macro recorder" it doesn't write any code for the formatting.

Unlike the 'cells' member, the 'comments' member doesn't have a 'characters' property to allow one to format part of the text.

I would appreciate any insight.
Thanks!
AC

 

[sugarflux]

Hi AC

You need to access the comment as a shape..

Dim myCom As Comment
Set myCom = ActiveCell.AddComment
myCom.Text "Hello This is my comment right here"
myCom.Shape.TextFrame.Characters(1, 10).Font.Bold = True

With 1 being the first character you want Bold and 10 being the length you want to make bold

Hope this helps!

sugarflux

 

[AcousticalConsultant]

Sugarflux,

Great! That's exactly what I needed. Works perfectly.
Thanks!

AC