Thread: make a sound when a certain value is reached in a specific cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Luke M Luke M is offline
external usenet poster
  
Posts: 2,722
Default make a sound when a certain value is reached in a specific cell
Right click on sheet tab, view code, paste this in.

Private Sub Worksheet_Calculate()
If Range("A2").Value 5 Then Beep
End Sub

Modify as needed.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"chuck" wrote:

I would like to have a sound generated when a sum in a specific cell is been
surpassed
Reply With QuoteReply With Quote