Beep accompanying My Message Box

[JMay]

I just entered into one of my spreadsheet modules:

Private Sub Worksheet_Activate()
MsgBox "Check Cell B1 - For Correct Month #"
End Sub

Now as I activate the (same) sheet I get (at no additional charge)
this "BEEP" << How can I disable this annoying sound?

TIA,

 

[Gord Dibben]

Private Sub Worksheet_Activate()
Application.EnableSound = False
MsgBox "Check Cell B1 - For Correct Month #"
End Sub

This is the only way I know of turning off a msgbox beep.


Gord Dibben MS Excel MVP

 

[Jim Cone]

A MsgBox with the Question button is quiet...
MsgBox "Did you check Cell B1 ?", vbQuestion
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"JMay" <[email protected]>
wrote in message
I just entered into one of my spreadsheet modules:

Private Sub Worksheet_Activate()
MsgBox "Check Cell B1 - For Correct Month #"
End Sub

Now as I activate the (same) sheet I get (at no additional charge)
this "BEEP" << How can I disable this annoying sound?

TIA,

 

[Dave Peterson]

I still got the beep. But the sounds that came with this download were stopped:


http://www.microsoft.com/downloads/...8310-457C733BE290&displaylang=en&Hash=N4HGGN8
or
http://snipurl.com/ucyf

(I figured that since I like the sounds, I should share the link!)

===
To the OP:
One of my coworkers used to snip the wires to the pc's internal speakers. That
may not be an option for everyone, though <vbg>.

 

[Dave Peterson]

It beeped for me (and my dog like hearing!)

A MsgBox with the Question button is quiet...
MsgBox "Did you check Cell B1 ?", vbQuestion
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware

"JMay" <[email protected]>
wrote in message
I just entered into one of my spreadsheet modules:

Private Sub Worksheet_Activate()
MsgBox "Check Cell B1 - For Correct Month #"
End Sub

Now as I activate the (same) sheet I get (at no additional charge)
this "BEEP" << How can I disable this annoying sound?

TIA,

 

[Jim Cone]

Dave,
They all beep except for the one with the question icon.
I have the hearing ability of a doorknob. <g>
Jim Cone
San Francisco, USA

Sub TestMe()
MsgBox "huh", vbInformation
MsgBox "huh", vbExclamation
MsgBox "huh", vbQuestion
MsgBox "huh", vbCritical
MsgBox "huh", vbYesNo
MsgBox "huh", vbAbortRetryIgnore
MsgBox "huh", vbRetryCancel
MsgBox "huh", vbOKCancel
End Sub


"Dave Peterson" <[email protected]>
wrote in message
It beeped for me (and my dog like hearing!)

 

[Dave Peterson]

Actually, I think that this is a windows setting

I could use Control Panel|Sounds And Audio Devices
and modify the Windows Question Event to turn off the associated sound.
(Like you already did!)

But I like the sound <vbg>.

I guess the OP could do the same thing--but this setting is a pc setting--not
something that excel will control.

 

[Jim Cone]

Dave,
I had already checked in the Sounds and Audio Devices list and
could not find anything relating to a "question" sound.
After reading your message, I checked again and it was there with
"none" applied to it. I believe it is the same person that hides my
car keys that is responsible. <g>
Jim Cone


"Dave Peterson" <[email protected]>
wrote in message
Actually, I think that this is a windows setting

I could use Control Panel|Sounds And Audio Devices
and modify the Windows Question Event to turn off the associated sound.
(Like you already did!)
But I like the sound <vbg>.
I guess the OP could do the same thing--but this setting is a pc setting--not
something that excel will control.

 

[JMay]

Thanks guys -- The ,vbQuestion add looks good
Jim May

 

[Dave Peterson]

I know about that person!

Dave,
I had already checked in the Sounds and Audio Devices list and
could not find anything relating to a "question" sound.
After reading your message, I checked again and it was there with
"none" applied to it. I believe it is the same person that hides my
car keys that is responsible. <g>
Jim Cone

"Dave Peterson" <[email protected]>
wrote in message
Actually, I think that this is a windows setting

I could use Control Panel|Sounds And Audio Devices
and modify the Windows Question Event to turn off the associated sound.
(Like you already did!)
But I like the sound <vbg>.
I guess the OP could do the same thing--but this setting is a pc setting--not
something that excel will control.