86836

Arabic characters don't show in excel VBA code

Question:

I can't write arabic strings in VBA code in excel, it shows as weird characters. Tried it on many machines with excel 2013 or 2010, on windows 8 or windows 7, with or without arabic proofing tools installed. Arabic language is already installed on all machines, system locale is arabic. There's no problem typing arabic characters on excel worksheets or even MS word but not in VBA code. Please help.

Answer1:

in VB Editor: - 1- click tools 2- Select Options... 3- click Editor Fofmat 4- Change font to(Courier New (Arabic)) 5- click OK now you can write in both English and Arabic I hope this will solve your problem

Answer2:

<strong>In Windows XP:</strong>

<ol><li>> Control Panel</li> <li>> Regional and Language Options</li> <li>> Advanced Tab</li> <li>> Select Arabic (depending on your country) You will be asked to insert the Windows CD, insert it and then browse to the I386 Folder then press ok.</li> <li>> restart the PC and it should work now fine.</li> </ol>

I beleve it's the same on Windows 7, the whole problem is in the non-unicode programs section set it to Arabic.

Answer3:

In win 10, you must change your system locale to match your language. You can find it here: 1- Press win key or click on it 2- Type region and click on it when windows finds it 3- Choose administrative tab 4- Under the language for non-unicode programs you will find "change system locale" key 5- A restart would be required

Recommend

  • How to Parse Json list in VB.NET Newtonsoft
  • VB.NET ManagementObject Help
  • Unable to delete a worksheet using EPPlus
  • Set Visual Studio (conditional) breakpoint on local variable value
  • calling a VB.net function from javascript
  • Copy and Paste Entire Row
  • How to make VBA count from 0 and not 1 in Excel Macro
  • transpose 2D array that exists as IEnumerable of IEnumerable
  • Removing levels from data frame read from CSV file - R
  • Tracking screen recorder in windows app
  • Using VBA to select a dynamic range of cells and create a chart
  • how to get the drawing graphic on picture box in c#
  • How do I embed a custom user-control in MS Word?
  • gulp.watch running same task multiple times when saving many files
  • UML diagram generator in Visual Studio 2010
  • CKeditor stripping font tags instead of converting to span
  • How can I add div content to a new page in jspdf?
  • Flex items with same property values are rendering in different sizes
  • jQuery: How to AJAXify WordPress Search?
  • Debugging VB6 Code From Visual Studio 2010
  • RxJava debounce by arbitrary value
  • Mysql - How to search for 26 records that each begins with the letter of the alphabet?
  • Declaring variable dynamically in VB.net
  • HTTP/2 streams vs HTTP/1.1 connections
  • Switching to Release Build causes runtime error in Web Reference
  • Why ng-show works with ng-repeat but ng-if doesn't? [duplicate]
  • Deleting and Updating values from a cusrsor adapter
  • Azure Cloud Service Web Role web pages do not load
  • Menu Color Fade on Hover with Jquery
  • Modifying destination and filename of gulp-svg-sprite
  • Join two tables and save into third-sql
  • 'TypeError' while using NSGA2 to solve Multi-objective prob. from pyopt-sparse in OpenMDAO
  • Display Images one by one with next and previous functionality
  • ORA-29908: missing primary invocation for ancillary operator
  • jquery mobile loadPage not working
  • How to get next/previous record number?
  • Data Validation Drop Down Box Arrow Disappearing
  • NSLayoutConstraint that would pin a view to the bottom edge of a superview
  • How do you join a server to an Active Directory (domain)?
  • How does Linux kernel interrupt the application?