How to enable Unicode in Excel 2016 VBA editor

Question

I have a worksheet with Hebrew word "שלום" in cell A1.

I am trying to run this VBA code:

Sub test()
    Dim str As String
    str = Range("A1")
    MsgBox str
End Sub

The message box displays:

????

Also, when I try to write Hebrew characters in VBA code:

if range("A1") = "שלום" then 'do something...'

instead of Hebrew letters I see gibberish.

I use Excel 2016 on Windows 10. Hebrew language pack is installed.

I did not face this problem in Excel 2010 on Windows 7.

Anyone with an idea for enabling Hebrew (or Unicode in general) in VBA code?

There better alternatives to **MsgBox** See: http://blog.nkadesign.com/2013/vba-unicode-strings-and-the-windows-api/ — Gary's Student, Jan 12 '16 at 13:40
Thanks, but my main goal is to be able to use hebrew characters inside the code... — Max Segal, Jan 12 '16 at 13:52
Have you tried VB Editor --> Tools --> Options --> Editor Format --> Font? — vacip, Jan 12 '16 at 18:32
It is always amazing how american programs are baffled by the fact that other alphabets exist... Éáöüóúőí. Ű. — vacip, Jan 12 '16 at 18:35

score 1 · Answer 1 · answered Jun 18 '20 at 10:17

You need to set system locale to Hebrew.

Different version of Windows has a slightly different way of doing it. Search the net for how to do it on your version of Windows. Basically, it is in Control Panel/Language & Region. If you are using Windows 10, it is under Settings/Time & Language/Region/Additional Date, Time, & Regional Setting (on the upper right hand corner of the window)/Region (change date, time, or number formats)/Administrative.

How to enable Unicode in Excel 2016 VBA editor

1 Answers1

Linked