Cannot display Chinese with Excel macro

Li, Clare 1 Reputation point
2021-04-26T04:24:03.817+00:00

I'm using Office/Excel 365 to run an Excel Macro, which is created by another person on another PC. The Macro runs successfully on other PCs, but failed on mine. The problem is it cannot display Chinese, for example, it try to display some Chinese with MsgBox (see 1st screenshot) , but the result is unreadable characters (see 2nd screenshot)

Also, the Macro will stop/break when the Macro contains Chinese characters. Please help on this.

Microsoft 365 Publishing
Microsoft 365 Publishing
Microsoft 365: Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line. Publishing: The process of preparing, producing, and releasing content for distribution or sale.
605 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 42,841 Reputation points
    2021-04-26T06:47:04.23+00:00

    Old VBA does not support Unicode characters, and with several thousend chinese character it exceed ASCII; so you simply can not present chineses characters in VBA:

    0 comments