Hi Carlton,
easy enough
Private Sub Worksheet_Calculate()
Static prevValue
If Range("I1").Value prevValue Then
Beep
prevValue = Range("I1").Value
End If
End Sub
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Carlton Patterson" wrote in message
...
Hello Bob,
while on the subject of sounds, is it possible to program excel to play
a sound as a value increments?
For example, lets say I have a cell with the current value of 1, I would
like to hear a single beep. Then, if the value goes up to 2 I would like
to hear another single beep and so on... Is that possible?
Cheers mate.
Carlton
*** Sent via Developersdex http://www.developersdex.com ***