I have a question in connection with display serbian cyrillic in message box. my sheet have column that contains values serbian cyrillic, how display those values in msgbox? Everytime i receive in msgbox ????? ?????. I think that i have to conversion from ansi to utf8 but i dont know how?
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Vba serbian cyrillic
0
Answers
0
Try going to File > Options > Language and changing the Editing and Display languages and see if that helps.
0
VBA's MsgBox isn't unicode compliant. This means that you have to use Serbian (Cyrillic) as the system language in order to properly display Cyrillic characters in message boxes. There are two alternatives.
One is to use an API to create a MsgBox which can dispaly unicode characters. This topic is discussed here (for Chinese characters, but the system is the same for Cyrillic). Follow all the links you find there. It's very interesting.
The other way is not to use a VBA MsgBox at all. Create a small form and use a TextBox or Label to display your message.