Posted to microsoft.public.excel.programming
|
|
Beep when Messagebox is displayed
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]
|