Excel Made Easy

Sound at end of macro in Excel

To do it in Excel, here is the answer:

  1. Option Explicit
  2. Public Sub AudibleAlarm()
  3. 'Code goes here
  4. Beep
  5. End Sub

a) "Beep" command can be used to provide an audible alarm.

 

You can find similar Excel Questions and Answer hereunder

1) How do I assign a macro to a shape using VBA?

2) How to record a macro in Excel VBA

3) I am using Excel for Project Management - how can I find End Date for a task given Start Date and Task duration considering only working days?

4) I want to automatically run an initialization procedure whenever I open my WorkBook so that it is ready for use - how can I achieve that?

5) How to debug a macro in Excel VBA

6) I frequently use a Macro - is there a way to quickly access the Macro in the Excel Ribbon?

7) Calling a macro from another workbook in Excel

8) How can I clear cell after activating a routine when there is a change in value of a cell?

9) How can I add a Timestamp after macro execution?

10) I want to automatically run a procedure whenever I close my WorkBook so that it is in a known state - how can I achieve that?

 

Here the previous and next chapter

Excel Made Easy was founded in 2002. Excel Made Easy is a service to people looking to learn Microsoft Excel or any other spreadsheet SW on the market.

We endeavor to provide the best service and support and to respond quickly to your questions.

Excel Made Easy is a proud sponsor of Dismantle-It.com the site that shows you the belly of your daily objects, Poupounette.com the site of cars loving cat and PowerPointMadeEasy.com the world top reference for PowerPoint Presentations questions and Pet Cemetery Online a site dedicated to your loving Pets.