Beep when Messagebox is displayed

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

Hi Diane,

Diane Alsing wrote:
> 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]

Even better - thank you!

"Jake Marx" wrote:

> Hi Diane,
>
> Diane Alsing wrote:
> > 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]
>