VBA with chinese character.

Hi,
I have an application coded using VBA, recently i wanted to change the input of a Value from english to chinese character but have problem doing so.
The problem is when i tried to input a character like ¿ the application display nothing at all...
But when i input ¿& it displayed ¿ but internally it still uses ¿& .

Is there a syntax i can use to only get the character?
csharp_learnerAsked:
Who is Participating?
 
danaseamanCommented:
From link you provided KAI is Unicode U+5F00.

Therefore:
CommandButton1.Caption = ChrW(&H5F00)

Here is a nice free program that shows all Unicode characters and their Decimal or Hex equivalents.

http://www.babelstone.co.uk/Software/BabelMap.html
0
 
danaseamanCommented:
Not sure what control you are using or how you are supplying the string caption.

Try this for Chinese sample:

Command1.Caption = "CHS: " & ChrW$(&H6B22) & ChrW$(&H8FCE)

0
 
csharp_learnerAuthor Commented:
thanks for the prompt reply
I was more looking for a syntax inorder to input the chinese character eg.$¿$ or &&¿&&
0
 
danaseamanCommented:
Char ¿ is Hex BF which is not a Chinese character. Can you show the character you are trying to use in a Unicode text file and post it here. Thanks.
0
 
csharp_learnerAuthor Commented:
sry not very sure how to give u the word in unicode format but the word is "Kai" http://www.chinese-tools.com/tools/sinograms.html?q=%E5%BC%80 is there a difference cos i'm using several differenct characters in my  input.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.