Beep when Messagebox is displayed

[Diane Alsing]

I have created a button that when pressed, runs some pieces of code. I would
like to play a sound, beep whatever to call attention to a message box when
displayed (because this code takes 10 hours to run!!) I would just like to
make sure people read that message before running the code.

Thank you
Regards,
Diane

 

[Jake Marx]

Hi Diane,

I have created a button that when pressed, runs some pieces of code.
I would like to play a sound, beep whatever to call attention to a
message box when displayed (because this code takes 10 hours to
run!!) I would just like to make sure people read that message
before running the code.

You could use vbExclamation for the second argument to the MsgBox function:

MsgBox "This is a test.", vbExclamation, "Test Title"

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]

 

[Diane Alsing]

Even better - thank you!

Hi Diane,

I have created a button that when pressed, runs some pieces of code.
I would like to play a sound, beep whatever to call attention to a
message box when displayed (because this code takes 10 hours to
run!!) I would just like to make sure people read that message
before running the code.

You could use vbExclamation for the second argument to the MsgBox function:

MsgBox "This is a test.", vbExclamation, "Test Title"

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]