Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum data, depending on cell content | Excel Worksheet Functions | |||
copy comment content to cell content as data not as comment | Excel Discussion (Misc queries) | |||
Beep Change The Sound | Excel Discussion (Misc queries) | |||
Help With Using Live Data - DDE | Excel Discussion (Misc queries) | |||
I have a live data feed that updates a cell all day. Can I graph? | Excel Discussion (Misc queries) |