Forum Discussion

JoeChbat's avatar
JoeChbat
Copper Contributor
Mar 31, 2020

Arabic VBA code not working - even after changing Unicode

Hello All,   I have typed a code that spells numbers in Arabic and the code is still not working properly. I could read it fine in the VBA at first, then when its in the formula cell, it shows str...
developer
excel
Formulas and Functions
Macros and VBA
office 365
JoeChbat's avatar
JoeChbat
Copper Contributor
Mar 31, 2020

ExcelExciting 

I just did some minor change in the Unicode and it worked.

ExcelExciting's avatar
ExcelExciting
MVP
Mar 31, 2020

HI JoeChbat 

 

Thanks for your feedback, could you please share what changes have you made.. it will be helpful for the community to learn from your experience

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer.

    • msamyGawad's avatar
      msamyGawad
      Copper Contributor
      Nov 01, 2024
      Please read solutions provided by me and others up there. Let us know your status
  • JoeChbat's avatar
    JoeChbat
    Copper Contributor
    Apr 05, 2020

    Thank you Faraz for the support.

    Here is the solution and how i fixed it.

     

    Region Settings > Additional Data, Time & Regional Settings > Change Date, Time, or Number Formats > Administrative > Change System Locale > Current System Locale > Arabic (Lebanon)

     

    I then typed the code on a new workbook and then COPY then PASTE on the existing workbook.

    (earlier, it did not work when i directly typed it on an existing workbook)

     

    attached is the code and workbook

     

    ExcelExciting 

     

Resources