I am currently trying to develop a macro that would display a msgbox similar to the 'Document recovery' dialog from Ms-Word: A vbOkCancel. Sometimes, the alert message opens up behind the open excel book and I have to manually minimize the book to select 'Yes'. This doesn't really work while it's stuck in the middle of execution waiting for me to select the message box option, so I have to Alt+D to minimize everything THEN select excel and click the message box. By John Walkenbach. The flexibility of the VBA buttons argument makes it easy to customize your Excel message boxes. You can choose which buttons to display, determine whether an icon appears, and decide which button is the default (the default button is “clicked” if the user presses Enter).
I have the same macro containing a few Arabic language string variables on two identical computers (same Windows XP Professional, same Office Professional (and obviously Word), same font in the Visual Basic editor.all settings are the same. On my laptop I can use those Arabic string variables in a message box (msgbox) as well as paste them into a document. On my desktop computer they appear as 'garbage' both in the message box and when pasted into a document. Even if I copy the same NORMAL.DOTM from one computer to the other, the same difference exists. It seems that on the desktop computer UNICODE is not being recognized and the text is converted to ANSI.
Can anyone tell me what settings I should change on the desktop computer to be able to use the Arabic strings as mentioned (msgbox and paste)? I'm replying myself - because I found the answer provided by MBMSOFT at the following address: MBMSOFT says: 1.In Control Panel > Regional and language options> advanced tab choose the native language you want to use in language for non-unicode programs 2.In VBA editor choose tools>options>editor format> font which support your language and it will work fine. (And it does - I entered Arabic (Lebanon) for that 'language for non-unicode programs' option and Times New Roman (Arabic) as the font in the VBA editor) Lee. Dear Ed, Thanks for your effort.
But here is what I replied on the office.microsoft.com site you referred me to: I edit documents in Arabic all the time. The problem I'm referring to is the inability to use an Arabic-language string variable in a macro to paste in a document or as text of a msgbox. Also, the macro in question WORKS PERFECTLY on one computer and DOES NOT WORK on another, both having the same Windows, same Office, same NORMAL.DOTM, same editor font, etc. Moreover, I tried using Greek strings instead of Arabic ones, and got the same result: pasted text is ANSI not Greek and msgbox text too (on ONE of the two computers, yet is fine on the other!). I should add that when I open the macro editor, there's my Arabic text, perfectly clear, in Arabic.
The only strange thing about it (on the computer on which it doesn't work) is that if you try to select it with the mouse, the letters appear to reverse their order until the entire string is selected, then seem to straighten themselves out. Somehow its UNICODE nature and its right-to-left direction are not being fully recognized - hence the inability to store it in a variable. If, on the other hand, my macro opens a Word document containing my Arabic strings and sets my Arabic macro variables from there, then: (1) it pastes correctly into another document but (2) the message in the message box is still???????????????? Themes hp sony ericsson c510 disassembly guide. !! Somewhere there's a setting.!
Shower Valve and Tub Spout Mounting. Positioning the shower valve on the center of your tub drain. Tile Master Atlanta presenting how to replace, install shower or bathtub rough in Valve! How to install rough in valve for tub. In another video from tub surround remodeling I am presenting Moen valve replacement - installation from. The proper valve position. Then measure the distance between the top of the tub drop outlet threads on the.
![Microsoft word vba message box options at post Microsoft word vba message box options at post](http://www.gmayor.com/Images_2008/word_v1.jpg)
Microsoft Word Vba Message Box Options Exchange
![Box Box](http://blog.nkadesign.com/wp-content/uploads/2008/05/sshot-104.png)
Excel Vba Message Box Options
Thanks again. I'm replying myself - because I found the answer provided by MBMSOFT at the following address: MBMSOFT says: 1.In Control Panel > Regional and language options> advanced tab choose the native language you want to use in language for non-unicode programs 2.In VBA editor choose tools>options>editor format> font which support your language and it will work fine. (And it does - I entered Arabic (Lebanon) for that 'language for non-unicode programs' option and Times New Roman (Arabic) as the font in the VBA editor) Lee.