Forum Discussion
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...
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
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