Macro - using symbols in MsgBox

[antaeusguy]

In worksheets, I would insert symbols by using Insert -> Symbols -> Symbol.

I would like to use some symbols in my macro's MsgBox, for example, the euro sign.

Does anyone knows how to perform this feat? Thanks for your kind help

 

[chuckles1066]

MsgBox (Chr(whatever the character no for the Euro sign is) & "Hello World")

 

[VoG]

This works for me

Sub test()
MsgBox "The price is " & Chr(128) & " 50.00"
End Sub

 

[VoG]

P.S. ASCII codes http://www.ascii-code.com/

 

[antaeusguy]

Thanks for the help guys, it works perfectly

 

[Ruddles]

Also check the Windows CHARMAP applet: Start > Run... charmap > Enter.

 

[antaeusguy]

Also check the Windows CHARMAP applet: Start > Run... charmap > Enter.

Cool... didn't know the windows has this neat app