Forum Discussion

Bui_Hien_Dat's avatar
Bui_Hien_Dat
Copper Contributor
Jan 07, 2020

VBA won't recoginze Vietnamese

Hi team,

 

VBA in my excel file won't recognize Vietnamese even when I have changed the language to Vietnamese in Control Panel > Region > Language for Non Unicode program and Setting in VBA > Tools > Options > Editor Format (Which I choose front that support Vietnamese. I still can type some characters but some don't work. Please advise me with this, more information is in attached file

 

Thanks all ❤️

excel
Macros and VBA
  • TuanBui68's avatar
    TuanBui68
    Copper Contributor
    Mar 24, 2025

    I also have this problem and would appreciate some help from the community.

    I am trying to remove the diacritics and the VBA code I was given:

        Accents = "áàạảãăắằặẳẵâấầậẩẫđéèẹẻẽêếềệểễíìịỉĩóòọỏõôốồộổỗơớờợởỡúùụủũưứừựửữýỳỵỷỹ"
        Replacements = "aaaaaăăăăăâââââđeeeeêêêêêiiiiiòòòòòôôôôôơơơơơuuuuuưưưưưyyyyy"

    in VBA, it became

        Accents = "áà??ãa?????â?????déè???ê?????íì??ióò??õô?????o?????úù??uu?????ý????"

     

  • Abiola1's avatar
    Abiola1
    MVP
    Jan 18, 2020
    Hello, sorry to hear that you cant use the Vietnamese despite all your efforts.
    Kindly send Frown to Excel so that they can look into the problem and fix:
    To send Frown:
    1. In the File tab, select Feedback
    2. Click on Frown

Resources