Search code examples
vbaexcelactivexinputbox

Non-Latin characters in VBA InputBox()

I am using VBA code to get data from user by using InputBox function. I want a user to write in Arabic.

But, when I run it, I found strange characters although I can write in Arabic normally in Excel sheets.

Can anyone help?

Solution

  • Make a custom form, that works as InputBox. There you would be able to write in any other language than English.

    Otherwise you would be getting the ?????????????????????

    Simply add a label element for the input and button elements for Ok and Cancel.

    enter image description here

    In general, this is much better than InputBox, because you can control the TextAlign property, which is different in Arabic than in English.