special asian characters in vba

[C111]

Hello,

I would like to insert some j apanese characters into vba but when I insert the characters I get: ??

Is it possible to have asian characters in the vba code?

thanks
C11

 

[pgc01]

Hi

You can write the characters using their codes. You can see them in the Insert->Symbol dialog or check in the web the Unicode codes for the characters.

For ex., I used the google translator to see the translation of house: 家

You can see in the Symbol dialog that its hex code is: 5BB6

Try this code to write the symbol in cell A1:

Range("A1").Value = ChrW(&H5BB6)

 

[C111]

Hi PGC

thank you very much! Your suggestion works perfectly

thanks again C111

 

[pgc01]

You're welcome. Thanks for the feedback.