View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Diane Alsing Diane Alsing is offline
external usenet poster
 
Posts: 18
Default 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]