How to get pi to appear in a message box when coded using VBA

[Oriya]

Hello all,

I'm really stuck on with trying to code a message box in VBA. I've got

Sub HINT_area_of_circle()
MsgBox " HINT: The formula to find the area of a circle is Area= Pi x Radiusē "
End Sub

And that all comes up fine and works, but i was wondering if there was a way to make "Pi" appear as the Pi symbol when the message box pops up? I've tried the alt code for pi but it seems that it isn't working.

Would anyone be able to help please?

[jindon]

Try ChrW(960) for π

[Oriya]

Thanks for the help, unfortunately that just returns p and not the pi symbol

[jindon]

Are you on Mac?
If so, no idea...

[jindon]

Oriya,

Sorry I forgot that msgbox doesn't support unicode characters.

So, 2 options.
1) Prepare a UserForm with one Label

Please Login or Register  to view this content.

2) or API

Please Login or Register  to view this content.