ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I add sound to a macro button in excel? (https://www.excelbanter.com/excel-discussion-misc-queries/245600-how-can-i-add-sound-macro-button-excel.html)

KCSA

How can I add sound to a macro button in excel?
 
How can I add sound to a macro button in excel?

Gary''s Student

How can I add sound to a macro button in excel?
 
Add a line like this to your macro:

Application.Speech.Speak "boing"

--
Gary''s Student - gsnu200907


"KCSA" wrote:

How can I add sound to a macro button in excel?


Jim Thomlinson

How can I add sound to a macro button in excel?
 
simplest

Sub test()
Beep
End Sub

If you want to play a wav file that is also possible with a little work.
--
HTH...

Jim Thomlinson


"KCSA" wrote:

How can I add sound to a macro button in excel?



All times are GMT +1. The time now is 06:25 AM.

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