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

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]

Or simply insert the Beep command before invoking the MsgBox.

--

Vasant


"Jake Marx" wrote in message
...
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]

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]

Vasant Nanavati wrote:
Or simply insert the Beep command before invoking the MsgBox.

Yeah, but that would be too simple, Vasant. <g

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

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