How to keep diacritics when sending vba string to excel / outlook?

Question

I would like to receive your opinion about the problem. It comes back to me every time I want to send a vba string that contains my diacritics in my native language to succeed or look.

I already changed the font in the vba editor, so it shows the correct labels in the code, and it works great when entering these labels manually in a sheet / perspective message. The problem occurs when a macro is executed, for example, the office mistakenly encodes the actions that vba sends to programs.

Example: I can enter the letter "Ł" in a cell.

I can also print the editor:

Sub example()
Range("A1").Value = "Ł"
End Sub

But when executing the macro, the range A1 shows "£".

Do you have any ideas where the problem is?

, vba . ( "Ł" "£".

! .

Answer 1

Unicode , , ChrW, . A :

ActiveSheet.Cells(1, 1).Value = ChrW(&H00c4)

, . Unicode & H, VBA , .