Unicode Language Support in the VBA editor

Question

I have a VBA project in Excel 2003.

This VBA project was written in Russian using Cyrillic encoding, so all the comments and messages are unreadable on my English OS (WindowsXP).

so the code on Russian machine looking like (OK):

Sub Select_I()
'Выделяет по текущей ячейке "построчный" диапазон для ввода данных по объекту

become on mine (NOT OK)

Sub Select_I()
'Âûäåëÿåò ïî òåêóùåé ÿ÷åéêå "ïîñòðî÷íûé" äèàïàçîí äëÿ ââîäà äàííûõ ïî îáúåêòó

Is there a way to "indicate" to the VBA editor what encoding to use?

Aleksey · Accepted Answer · 2013-07-31 06:05:51Z

2

I've found a workaround for me - when copy-paste Russian text from VBA editor to somewhere else in Windows and keyboard at that moment is in Russian layout, then pasted Russian symbols are displayed correctly.

answered Jul 31, 2013 at 6:05

Aleksey

4877 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

enderland · Accepted Answer · 2012-08-19 02:21:35Z

1

Try the following (I cannot test this very easily but it should work):

Control Panel --> Date, Time, Language, and Regional Options --> Regional and Language Options --> Advanced

and set the language for non-Unicode programs to the appropriate language (Russian it seems in your case).

answered Aug 19, 2012 at 2:21

enderland

14.2k18 gold badges105 silver badges157 bronze badges

Collectives™ on Stack Overflow

Unicode Language Support in the VBA editor

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related