[RESOLVED] [Access] Hebrew letters in Msgbox()

[VBA newbie]

Hi,

Is there any possibility to show Hebrew characters in a VBA Msgbox()

Thanks for your help

[westconn1]

you should do a search for unicode messagebox, i am not sure if it would be a windows API call or a 3rd party control, but i am sure it would exist

[VBA newbie]

you should do a search for unicode messagebox, i am not sure if it would be a windows API call or a 3rd party control, but i am sure it would exist

Thanks for your reply.

I found this:
https://answers.microsoft.com/en-us/...6-95af5f29e324
But i'm looking if there is something more simple.

[VBA newbie]

https://answers.microsoft.com/en-us/...6-95af5f29e324

[westconn1]

something more simple

unless you can find something that has already been done by someone else, which they probably want to charge for, you are probably stuck with similar amounts of code

you can probably just put the whole code into a module, which you can then just add to any project

in your code, just call like
MsgBoxW with the normal parameters for standard msgbox, no need to edit the code unless some issue like application.name will cause an error, you could easily change to app.exename or similar

[VBA newbie]

in your code, just call like MsgBoxW with the normal parameters for standard msgbox

I can't add the Hebrew text directly in the code, if yes i get the same question marks, what I did is to create a table with Hebrew strings, then declare a variable with dlookup to the specific string in the table, and using this variable for the prompt. still its a headache to add each time a string in the table instead directly in the code.

BTW, how can I make that the message box should be RTL?

Thanks

[westconn1]

there is no easy way for unicode in vba, you can use byte arrays to work with unicode strings, some years ago, i did an example with arabic, not very easy, and as i do not read arabic hard to know if the results were correct, the windows clipboard should also handle unicode correctly

[VBA newbie]

And how about making the message box show up RTL?

[westconn1]

i am not sure there is any option available to do rtl with a vb6 /vba messagebox

you could possibly use a vb.net class as an activex called from your VBA

[VBA newbie]

i am not sure there is any option available to do rtl with a vb6 /vba messagebox

I am not talking about the VB MsgBox(), my question is about the unicode message box function in the link above.

[westconn1]

my question is about the unicode message box function in the link above.

as far as i can tell they are the same thing, just wrapped differently

try adding the value of vbmsgboxrtlreading to the buttons, though i am not sure if it will work

in the example from the link

  Select Case MsgBoxW(Msg, vbYesNoCancel Or vbQuestion Or vbDefaultButton2 Or vbMsgBoxRtlReading)

[VBA newbie]

as far as i can tell they are the same thing, just wrapped differently

try adding the value of vbmsgboxrtlreading to the buttons, though i am not sure if it will work

in the example from the link

  Select Case MsgBoxW(Msg, vbYesNoCancel Or vbQuestion Or vbDefaultButton2 Or vbMsgBoxRtlReading)

This worked just for the title not for the prompt. but by adding vbMsgBoxRtlReading + vbMsgBoxRight it got resolved, now everything is fine.

Thanks for your great help!

[westconn1]

pls mark thread resolved