Arabic VBA code not working - even after changing Unicode

%3CLINGO-SUB%20id%3D%22lingo-sub-1267577%22%20slang%3D%22en-US%22%3EArabic%20VBA%20code%20not%20working%20-%20even%20after%20changing%20Unicode%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1267577%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20typed%20a%20code%20that%20spells%20numbers%20in%20Arabic%20and%20the%20code%20is%20still%20not%20working%20properly.%3C%2FP%3E%3CP%3EI%20could%20read%20it%20fine%20in%20the%20VBA%20at%20first%2C%20then%20when%20its%20in%20the%20formula%20cell%2C%20it%20shows%20strange%20characters%20not%20related%20to%20Arabic%20or%20question%20marks%26nbsp%3B%20%22%3F%3F%3F%3F%3F%3F%3F%3F%3F%3F%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1267577%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1267703%22%20slang%3D%22en-US%22%3ERe%3A%20Arabic%20VBA%20code%20not%20working%20-%20even%20after%20changing%20Unicode%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1267703%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F602485%22%20target%3D%22_blank%22%3E%40JoeChbat%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20you%20please%20attached%20the%20sample%20file%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22lia-message-body%20lia-component-message-view-widget-body%20lia-component-body-signature-highlight-escalation%20lia-component-message-view-widget-body-signature-highlight-escalation%22%3E%3CDIV%20class%3D%22lia-message-body-content%22%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%20Answer%3C%2FSPAN%3E.%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1267802%22%20slang%3D%22en-US%22%3ERe%3A%20Arabic%20VBA%20code%20not%20working%20-%20even%20after%20changing%20Unicode%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1267802%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156456%22%20target%3D%22_blank%22%3E%40Faraz%20Shaikh%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20just%20did%20some%20minor%20change%20in%20the%20Unicode%20and%20it%20worked.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1267807%22%20slang%3D%22en-US%22%3ERe%3A%20Arabic%20VBA%20code%20not%20working%20-%20even%20after%20changing%20Unicode%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1267807%22%20slang%3D%22en-US%22%3E%3CP%3EHI%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F602485%22%20target%3D%22_blank%22%3E%40JoeChbat%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20feedback%2C%20could%20you%20please%20share%20what%20changes%20have%20you%20made..%20it%20will%20be%20helpful%20for%20the%20community%20to%20learn%20from%20your%20experience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22lia-message-body%20lia-component-message-view-widget-body%20lia-component-body-signature-highlight-escalation%20lia-component-message-view-widget-body-signature-highlight-escalation%22%3E%3CDIV%20class%3D%22lia-message-body-content%22%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%20Answer%3C%2FSPAN%3E.%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1282114%22%20slang%3D%22en-US%22%3ERe%3A%20Arabic%20VBA%20code%20not%20working%20-%20even%20after%20changing%20Unicode%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1282114%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20Faraz%20for%20the%20support.%3C%2FP%3E%3CP%3EHere%20is%20the%20solution%20and%20how%20i%20fixed%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegion%20Settings%20%26gt%3B%20Additional%20Data%2C%20Time%20%26amp%3B%20Regional%20Settings%20%26gt%3B%20Change%20Date%2C%20Time%2C%20or%20Number%20Formats%20%26gt%3B%20Administrative%20%26gt%3B%20Change%20System%20Locale%20%26gt%3B%20Current%20System%20Locale%20%26gt%3B%20Arabic%20(Lebanon)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20then%20typed%20the%20code%20on%20a%20new%20workbook%20and%20then%20COPY%20then%20PASTE%20on%20the%20existing%20workbook.%3C%2FP%3E%3CP%3E(earlier%2C%20it%20did%20not%20work%20when%20i%20directly%20typed%20it%20on%20an%20existing%20workbook)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eattached%20is%20the%20code%20and%20workbook%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156456%22%20target%3D%22_blank%22%3E%40Faraz%20Shaikh%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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 strange characters not related to Arabic or question marks  "??????????"

 

 

4 Replies
Highlighted

@JoeChbat 

 

Could you please attached the sample file 

 

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.

Highlighted

@Faraz Shaikh 

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

Highlighted

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.

Highlighted

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

 

@Faraz Shaikh