garbled codes in VBA

[yxz152830]

gurus,
this is something that I got from some learning materials. Below is part of the code and it shows some weird characters.
I know little of UTF-8 or unicode or other language standardization systems. Could anyone tell me what to do next? Thanks!

 Dim arr, wb As Workbook, key, dz, dzz
 Dim lngLastRow As Long
 Dim rng As Range
 dzz = Cells(4, 12)
 key = InputBox("ÇëÊäÈëÎļþÃû£¨ÀýÈ磺ÈÕÆÚ+Åú´Î£©", "TNT DMSÊý¾Ýµ¼³ö", "¹ãÖÝ")

 

[Domenic]

The Visual Basic Editor does not support Unicode characters. However, as a workaround, you can enter your text in a worksheet cell in Excel, and then you can refer to that cell for the text. Note that you'll need to use the InputBox method of the Application object, instead of the InputBox function, like this . . .

key = Application.InputBox(Range("A1").Value)

Hope this helps!

 

[yxz152830]

is there any patch that I can install? If someone wrote the code then he probably didnt see any garbled characters or letters.

The Visual Basic Editor does not support Unicode characters. However, as a workaround, you can enter your text in a worksheet cell in Excel, and then you can refer to that cell for the text. Note that you'll need to use the InputBox method of the Application object, instead of the InputBox function, like this . . .

key = Application.InputBox(Range("A1").Value)

Hope this helps!

 

[Domenic]

Sorry, I'm not aware of one.

 

[yxz152830]

Sorry, I'm not aware of one.

what is the reason behind this? Why could someone write such codes? Apparently he was writing them in normal typing and when i downloaded the file the letters are all of a sudden unrecognizable?

 

[RoryA]

I'd imagine it's to do with the language installation of your version of Windows.