Cannot Change Excel Ole object Command Button Text's Font property .Bold and .Italic = False

[Clement Lo]

Hi I have been struggling with this bugs for a few years and managed to resolve it today with copilot help.

It seem Microsoft have this .bold and .italic property set to a tristate Boolean , the traditional False and True value will always map it to True, You must use msoFalse for False value and msoTrue for True value .

e.g. to turn off the Bolding effect.

.Bold = msoFalse

More of this info here

MsoTriState Enum (Microsoft.Office.Core)​

Specifies a tri-state Boolean value.

Hope your days are better when you solve this bug .

Cheers

 

[saboh12617]

Hello,
It is not really a bug. Those values "msoTrue" etc. are simply "fancy names" for numeric constants (integers, not booleans) used internally. As it is easier for us to understand ".Bold = msoTrue" rather than ".Bold = -1".
It's the same as VbCrLf representing Chr(13) + Chr(10) for example.
If you use the values indicated in the table on the link you provided, instead of the names, it will work.
Like so :

.Bold = -1