Fontstyle in Excel VBA is in local language. How to convert to English?

[rlaemmler]

Hi,

In a German version of Excel the fontstyle "Bold" is defined "Fett" and
"Italic" is defined "Kursiv". The VBA always returns the German
interpretation from the cell fontstyle. The funny thing is you can
initialize a cell fontstyle using the english definitions and it works
but I don't know how to get the fontstyle from a cell in english?

Any ideas?

Reto

 

[Ron de Bruin]

Hi Reto

I never used the fontstyle in the Dutch version
I always use this in VBA

ActiveCell.Font.Bold = True
ActiveCell.Font.Italic = True
ActiveCell.Font.Underline = True

 

[rlaemmler]

Ron,

Thanks a lot. That helped. That's simply and funny I didn't see that
myself.

Reto