Thread
:
Associating a sound to a MsgBox ?
View Single Post
#
5
Posted to microsoft.public.excel.programming
Junkyard Engineer
external usenet poster
Posts: 18
Associating a sound to a MsgBox ?
simplest things are the best !
Thanks
"Jake Marx" a écrit dans le message de news:
...
Hi Junkyard,
Junkyard Engineer wrote:
I have this msgbox asking yes/no question. How can I associate a
sound with it ?
Answer = MsgBox("Do you want to continue ?", vbYesNo + 256 +
vbQuestion, "ATTENTION")
If Answer = vbNo Then Exit Sub
You could use vbExclamation instead of vbQuestion - that will give the
user a beep. MS uses it in the "Save changes?" dialog in Excel.
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]
Reply With Quote
Junkyard Engineer
View Public Profile
Find all posts by Junkyard Engineer