I have a spreadsheet that gets its values from a query. When those values
change below a certain number then I would like to hear an audio warning. How
can this be done? Anyone responding please tell me exactly where to paste the
code since I'm not a programmer.
The data is on a sheet called "runs", the cells in question are "K4:K9",
the cells contain numbers"K4=20,K5=88,K6=22,K7=22,K8=75,K9=44". These values
come from a query called "Monitor". Whenever these cells change in value,
whether they go up or down, I would like an audio warning.
thank you

Right-click on the sheet tab and select View Code. Copy this code and paste
it in there. Change < 10 to whatever number you want. HTH, James

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 11 And (Target.Row >= 4 Or Target.Row <= 9) Then
If Target < 10 Then Beep
End If
End Sub


"Ruben" <(E-Mail Removed)> wrote in message
news:36B55061-834F-4956-8153-(E-Mail Removed)...
>I have a spreadsheet that gets its values from a query. When those values
> change below a certain number then I would like to hear an audio warning.
> How
> can this be done? Anyone responding please tell me exactly where to paste
> the
> code since I'm not a programmer.
> The data is on a sheet called "runs", the cells in question are "K4:K9",
> the cells contain numbers"K4=20,K5=88,K6=22,K7=22,K8=75,K9=44". These
> values
> come from a query called "Monitor". Whenever these cells change in value,
> whether they go up or down, I would like an audio warning.
> thank you
>