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: 46
 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: 46
 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: 18830
 Joined: 2006-05-11
Hello Henjo,

I've never seen this. Google suggests Excel doesn't have such a feature; instead, people play with Windows settings:

https://excel.tips.net/T002974_Setting_the_Default_Font_Size_for_Comment_Balloons.html
https://www.sagecity.com/blog/b/excel-tips-tricks-list/posts/how-to-change-the-default-font-size-for-excel-comments
https://answers.microsoft.com/en-us/msoffice/forum/all/upgraded-to-windows-10-how-can-i-change-the-the/27bf681c-5cc6-495b-89ba-9070a02cee8d


Andrei Smolin
Add-in Express Team Leader
Posted 09 Jun, 2020 02:36:04 Top