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

S

Syd

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
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to call a worksheet (as a function) 18
VBA to run all variable combinations in a calculation model and store result 6
sound clip as a result of conditional formatting... ? 6
colour change as a result of a figure 1
Formula Help - Perform a calculation only if the result falls between 2 values 4
Inputting a value and receiving a result 4
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
a if calculation help 2

Top