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

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

Thanks

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

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


--
Cheers,
Shane Devenshire


"Bhavana" wrote:

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

Thanks