Inserting picture or changing the font in Macro Msgbox

[Realistic]

Hi guys

In the Msgbox (While recording Macro, if the number = ... , apply msgbox .. etc)

- how can inseret a picturer?
- How can I change the font, styele, size, and color in the msgbox?
- Can I remove the sound that appears when i click on it?

THX

[Bryan Hessey]

Hi guys

In the Msgbox (While recording Macro, if the number = ... , apply msgbox .. etc)

- how can inseret a picturer?
- How can I change the font, styele, size, and color in the msgbox?
- Can I remove the sound that appears when i click on it?

THX

Hi,

No

You can create and use a Userform with the attributes you require, but even then I doubt you can suppress any sound made.

hth
---

[Carim]

Hi,

Bryan is right you cannot change MsgBox fonts

As far as the picture is concerned, following instruction should help

Please Login or Register  to view this content.

HTH
Carim

[Realistic]

Hi Bryan,

What is the userform?

[Bryan Hessey]

Hi Bryan,

What is the userform?

Hi,

In VB editor (rightmouse the worksheet tab and View Code), Insert, Userform
and draw the required shapes and set the conditions etc.

hth
---