Smiley icon in code

[JackDanIce]

Hi,

I have the following code:

MsgBox = "(Unless you know what you're doing)"

And would like to add a smiley face between the last two characters 'g' and ')' I'd like to use an actual symbol e.g. so it reads:

(Unless you know what you're doing )

And not (Unless you know what you're doing )

Any suggestions on how I can code this?

Thanks,
Jack

 

[Andrew Poulsom]

Sorry, that's not possible. The MsgBox prompt is plain text.

 

[JackDanIce]

Nevermind, thanks Andrew

 

[de ware]

In stead of a message box you could use a userform.
There you can use both tekst and pictures.
Just make a pictuer of the smiley...

At the bottom of it you can place the same buttons as in a messagebox...

(Unless you don't understand what I mean )

 

[JackDanIce]

Hi de ware

I've got a simple button click that unhides a worksheet (where I store a load of variables for use in my main macro) and I don't want an end user to see that worksheet unless they're sure they know what they're doing. So using a MsgBox with vbCritical to warn them before unhiding but no need for a vbQuestion.

At this stage, I'm happy enough using a MsgBox but thanks for the suggestion!

Jack