VBA Cannot read ZH_CN (Chinese) Language MAC OS

RudRud 0 Reputation points
2023-05-04T10:45:54.98+00:00

Hi, I'm encountering VBA that cannot read/see/write Chinese language,

It will be showing Chinese language when I change system language into Chinese, If there's any way without changing system language into Chinese instead? Looking for the solution here

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,619 questions
{count} votes

1 answer

Sort by: Most helpful
  1. AllenXu-MSFT 17,581 Reputation points Microsoft Vendor
    2023-05-05T06:21:48.69+00:00

    Hi @RudRud,

    As per my research, the marked answer in this thread may help in this case: Using multiple language (english, chinese, japanese) in VBA. Use bytearrays instead of strings to declare the strings. That way, the VBA IDE can store the data independent of locale settings.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.