ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   MsgBox sounds (https://www.excelbanter.com/excel-programming/429648-re-msgbox-sounds.html)

Tim Williams[_2_]

MsgBox sounds
 
If there's no other solution you could replace the messagebox with a custom
form.

Tim

"Rich" wrote in message
...
Thanks for the prompt response...however, this does not solve the problem.
The tickbox for "feedback with sound" was already un-checked...and even
with
these commands in the coding, the MsgBox still makes an annoying sound!
(I guess I should have mentioned this was turned off in my original post)

Any more clues or ideas?

"JLGWhiz" wrote:

To disable:

Application.EnableSound = False

To enable:


Application.EnableSound = True



"Rich" wrote in message
...
Hi,

I am using a MsgBox command in a program which is being distributed to
a
large number of people across the business. I usually have my sound
muted
so
did not notice anything...but since sending out have received
complaints
that
the MsgBox's make loads of noise.

Using simple code in Excel 2003:

MsgBox MsgBoxText, 64, MsgBoxTitle

Can anyone please tell me how I can disable the sounds...and then
re-enable
them once the text box has been displayed.

Thanks,

Rich








All times are GMT +1. The time now is 10:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com