Help Playing a sound if a cell's value chjanges as a result of a calculation
 

Can someone help me..

I need to use VBA Excel to detect if a cell's value becomes greater or less
than some prescribed values as a result of a calculation and play a sound
whenever it happens.
(If $B3 7 or < 5 ...Play a sound)

The change_event works if I type the value into the cell but I cannot get it
to work if the cells value changes as a result of a calculation.

Please help

Syd

Help Playing a sound if a cell's value chjanges as a result of a c
 

The Worksheet change event wo't trigger because of a cell change via
calculation. Try the Worksheet calculate event.
--
Gary's Student


"Syd" wrote:

Can someone help me..

I need to use VBA Excel to detect if a cell's value becomes greater or less
than some prescribed values as a result of a calculation and play a sound
whenever it happens.
(If $B3 7 or < 5 ...Play a sound)

The change_event works if I type the value into the cell but I cannot get it
to work if the cells value changes as a result of a calculation.

Please help

Syd