VBA: Pasting cyrillic string in vba editor

[ivanovmr]

Hello,

I am using excel with other RPA tools for automation. I am trying to execute a macros in excel which VBA code uncludes a cyrillic text, maybe the specific thing there is that my VBA code is stored in variable which I hand to the editor.

So all works perfect exept that cyrillic text is displayed as “?????”

I have tried to change region and language settings but without effect.

May anyone help me to make my cyrillic text visible and used in VBA editor?

 

[Domenic]

Unfortunately, the Visual Basic Editor doesn't support Unicode characters.

How about storing the text in a worksheet cell, and then assigning it to a variable?

Or, how about storing the text in a defined name (Ribbon >> Formulas tab>> Defined Names group>> Define Name)?

 

[ivanovmr]

Unfortunately, the Visual Basic Editor doesn't support Unicode characters.

How about storing the text in a worksheet cell, and then assigning it to a variable?

Or, how about storing the text in a defined name (Ribbon >> Formulas tab>> Defined Names group>> Define Name)?

Thank you for your fast response and for the hints. I will try these options

Do you know is there a option to store a variable some in Excel and then to call it dynamically when its needed?

 

[Domenic]

Thank you for your fast response and for the hints. I will try these options

Do you know is there a option to store a variable some in Excel and then to call it dynamically when its needed?

I'm not sure what you're trying to do exactly, but you don't necessarily need to assign the worksheet cell value to a variable. You can simply refer to the cell when needed.