Chinese characters on labels and messages

[Excelgreenhand]

If anyone has the experience to put Chinese characters on the caption of Command buttons or labels or messages? I have tried and the input seems to appear as "????". Putting on text fields with Chinese characters is OK. Thank you!

 

[yky]

I created a user form and named it "表一", a command bottom "好", and a label "標籤". They all work, meaning on screen they all display Chinese without problems.

 

[Excelgreenhand]

yky,

Thanks for the prompt reply. I have copied the Chinese characters from the Excel spreadsheet, highlighted then paste on the Label caption, code and Optionbutton text. NO Chinese characters showed up instead they appeared as "???". I forget to reveal I am using English Windows 7 and Office 2007 (English version). Kindly let me know please.

 

[yky]

I'm using English version of Windows 7 and English version of Excel 2010. I have tried entering Chinese characters using a Chinese input method to the caption in the properties windows of label, button, form and also directly copy and paste Chinese characters to the design window. Both ways work for me.

The fact that you see ??? instead of Chinese characters seems to me your Excel doesn't support Unicode but I believe it does. So, I really don't know why it doesn't work for you. The only suggestion I can make is go to Control Panel/Region and Language/Administrative and click on the button "Change system locale". There, you can select a language to display for programs that do not support Unicode. I don't know if this will help because I believe Excel doesn't need this but I'm running out of ideas.

 

[Excelgreenhand]

yky,

Thanks. It works after I change the locale. If you are still willing to extend further I have the following issues:
1. about Chinese character sorting, is it the same as English
2. how to convert between Simple and Traditional

 

[yky]

I have been doing Chinese on computers for more than 20 years. Never once did I need to sort Chinese. So, I don't have real experience of sorting Chinese. I have heard that there are several ways of sorting Chinese, by phonetic symbol (bopomofo), by stroke, etc. but I have never tried any of them.

I once had a DOS program which could convert between simplified and traditional Chinese but that's 20 years ago. I don't have it anymore. I believe Google Translate can do it.

 

[Excelgreenhand]

Thank you and I know who to ask for more questions.

 

[Excelgreenhand]

My bad. One more thing I forget to ask.
Do you have any formula to convert our calendar date to Lunar year date!?
Thank you!

 

[yky]

I don't think there is a formula to do so. There are too many exceptions for a formula to work. What works is a look-up table. The following look-up table is from Hong Kong government.

Gregorian-Lunar Calendar Conversion Table

 

[Excelgreenhand]

謝謝!