Pop up window

[emilemil22]

I am making a userform in excel using VBA.

I want whenver a textbox1 is left blank after clicking a save button a pop up window is trigerred saying "the textboox1 cannot be left blank"

I know how to do this

Function ValidateForm() As Boolean
ValidateForm = True

If Trim(a1.Value) = "" Then
MsgBox "Question number 1.1 can't be left blank.", vbOKOnly + vbInformation, "Name"

However, I want the MsgBox to be in another language (Russian), however when I write it in Russian in macros it simly appears as question marks "???????????" and respectvely in pop up window the message appears in question marks.

Does anyone have a solution for this?


Many thanks,

 

[Jaafar Tribak]

The VB Editor doesn't support unicode characters so you will first need to change the language for non-unicode programs as follows :

1- Go to Control Panel
2- Administrative Tab
3- Change System Locale
4- Select the language (Arabic in your case)
5-Reboot your computer for the new settings to take effect.
6- In the VBA Editor,go to Tools>Options>Editor Format> and choose Russian(or Cyrillic) font

Now you should be able to write code

 

[Jaafar Tribak]

Sorry I meant : Russian in Point #4 (Not Arabic which is the one I use)