Cell comment suddenly bold?

Add-in Express™ Support Service
That's what is more important than anything else

Cell comment suddenly bold?
 
Henjo van Rees




Posts: 31
Joined: 2018-12-10
I add a cell comment to the cell containing the function (UDF).
This comment is just plain text, no formatting:

Range callingCell = ....;
callingCell.AddComment(text);
callingCell.Comment.Shape.Height = 50;
callingCell.Comment.Shape.Width = 200;

I just noticed that these comments are bold now, without having changed any of the related code.

How can I set the font or text styling for the comment?
I can't find the correct property, only WordArt related properties
Posted 08 Jun, 2020 09:23:26 Top
Henjo van Rees




Posts: 31
Joined: 2018-12-10
Ok, found that I can set the font per character like this:

callingCell.Comment.Shape.TextFrame.Characters(0, message.Length).Font.Bold = false;

Is it possible to set the default font formatting in advance, before the text?
Posted 08 Jun, 2020 09:38:35 Top
Andrei Smolin


Add-in Express team


Posts: 17324
Joined: 2006-05-11
Posted 09 Jun, 2020 02:36:04 Top