Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I created a macro to sound chimes when a number entered in column C exceeds
360. I need it to work when the number is the result of a calculation rather than manual entry. Is this possible? Could anyone suggest changes to the following code to accomplish this please? Thanks! Option Explicit Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Application.Run "chimes" End Sub Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 3 Then On Error GoTo errors If Target.Value 360 Then GoTo errors End If Exit Sub errors: On Error GoTo 0 Application.Run "chimes" End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pulling Data off Web - Need Function Help | Excel Worksheet Functions | |||
is there a limit to the number of rows a worksheet can have? | Excel Discussion (Misc queries) | |||
Is there a limit number of characters for cells in pivot Tables? | Excel Discussion (Misc queries) | |||
How do I limit the number of times an Excel workbook can be opene. | Excel Discussion (Misc queries) | |||
How do I limit the number of rows in an Excel worksheet. | Excel Worksheet Functions |