How to turn off messagebox beeps and sounds

[Oliver Dewar]

Hi All.

Just wondering if there's a way in VBA to turn off all messagebox bleeps and sounds for a workbook... or to turn off each messagebox bleep individually. (I don't mind if the whole workbook runs silently to achieve this).

I have excel 2007 and windows 7.

 

[GTO]

If you don't mind the question icon, it would seem easiest to me to use vbQuestion in the buttons arg.

Edit: Or... just create a userform that looks like a msgbox

 

[Oliver Dewar]

That's a good idea... I can use that for questions and an underfined one (which renders with no icon) for alerts etc.