Visual Basic Languages

Question

I have Office 2013 with a language pack (Hebrew for the matter), but the Excel Visual Basic doesn't recognize other language than English.

What is the problem?

Answer 1

You shouldn't use the ????? but use Sheet1 instead.

If you use

Dim strSheet As String

strSheet = Sheet1.Name

the variable strSheet will contain the correct name in Hebrew, even if you cannot display it correctly in the Visual Basic Editor.

Apart from that: I'm not an expert in non-western languages, so I'll have to leave this to others, sorry.

Answer 2

Thank you very much for your response.

Unfortunately, in my case, I get question marks as sheets names in Hebrew:

Of course, the code doesn't know how to handle it.

Let me just say that in previous version of Windows (Now 10, before: 7), and using the same Office 2013 - Everything was OK. Maybe the problem is with Windows 10...? I have installed Hebrew as a language in Windows 10 Settings.

Please advise.

Answer 3

I'm afraid you cannot use Hebrew strings within your code.

Each worksheet has a "code name" that is visible in the Visual Basic Editor only:

In this screenshot, "This is my sheet" is the name displayed on the worksheet tab. This would be in Hebrew in your case.

"Sheet1" is the code name. It is always in western characters. You can refer to Sheet1 in your code, or do something like this:

Dim strSheet As String

strSheet = Sheet1.Name

strSheet will contain the name in Hebrew.

Answer 4

Thank you very much for your response.

Let me explain in details:

1. The VB doesn't recognize sheets names in Hebrew.
2. I have to use strings in Hebrew within the code (in English, of course). It can be the Sheets names as I specified above, as comments, or other uses.

Answer 5

The Visual Basic Editor is in English only, and you cannot enter Hebrew (or other non-western) characters in your code.

It can handle cell values that contain Hebrew text, though.