Mandarin/Chinese in labels in VBA userforms? RRS feed

  • Question

  • Can I write text in a label in a VBA userform in mandarin?

    I have tried changing the font from Tahoma/Western Script to e.g. @FangSong/CHINESE_BIG5 but it has no effect.

    I have not yet installed a chinese language pack (will wait till I actually get the assignment) and expect that that will make a difference.

    Anyone with experience in this field?

    Thanks in advance!


    Tuesday, May 21, 2013 9:27 AM

All replies

  • you can use this: (it's the code for special sign's)

    Chr() with between the () the unicode number of the sign, if you don't know the unicode number, you can go to the special sign program that is normally on your laptop or you can use the code:

    - first you select the character you want to know the unicode of

    then you run this code

    dim sign as string
    sign = activewindow.selection
    msgbox cstr(asc(sign))

    in the same way you can make a convertor, were you change every letter (a, b, c) on your keyboard by a mandarin sign

    BUT: it can be that there is no unicode sign for your mandarin letters/words, in that case this whole procedure won't work

    • Proposed as answer by Mr. Rik Thursday, May 23, 2013 7:29 PM
    Thursday, May 23, 2013 7:29 PM