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