Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The below code
'------------------------- Private Sub Worksheet_Change(ByVal Target As Range) Dim c As Range On Error Resume Next For Each c In Range("D2:G5") If Not Application.Intersect(Target, c.Precedents) Is Nothing Then Interaction.Beep End If Next c On Error GoTo 0 End Sub '---------------------- sound on each minute change of my system clock. You see, cells A1 and B1 displays the system clock hour and minute values. And the watching cells (Range D2:G5) look to the values displayed in A1 and B1. Then the main macro is executed in minute intervals to let A1 and B1 refresh their displays. Now although no "display" change is valid in the watched cells the sound alarm beeps in minute intervals too. Maybe my other suggestion may prevent that. I hope I didn't confuse you... Hope we can solve this problem. Regards J_J |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sounds | Excel Discussion (Misc queries) | |||
sounds in Excel | Excel Discussion (Misc queries) | |||
Excel Sounds | Excel Discussion (Misc queries) | |||
convert time from 60 minute hour to 100 minute hour | Excel Discussion (Misc queries) | |||
convert 100 minute hour to a 60 minute hour | Excel Worksheet Functions |