how to add sound ( beep ) if cell content changes in live data

[Bhavana]

how to add sound ( beep ) if cell content changes in live data ?

Thanks

 

[ShaneDevenshire]

Hi,

Add the following code to the appropriate Sheet object:

Private Sub Worksheet_Change(ByVal Target As Range)
Beep
End Sub

or the following code to the thisWorkbook object:

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Beep
End Sub