ExcelBanter - Beep Change The Sound

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Beep Change The Sound (https://www.excelbanter.com/excel-discussion-misc-queries/97927-beep-change-sound.html)

Bob

Beep Change The Sound

Part of the code I am using is:

If IsError(res) Then
Beep
Else

How can I change the Beep "Sound" to something else. Perhaps some other
default sounds in XP. What would the code be?

Thanks,
Bob

All times are GMT +1. The time now is 02:07 PM.