Detect Value change of a Cell

[Guest]

How can i detect the cell value changed (which linked to a website table),
then trigger excel to play a sound , when the value of that cell is not equal
to '0' or something .

I know little of VB programming only.

thanks man

 

[Tom Ogilvy]

http://support.microsoft.com/default.aspx?scid=kb;en-us;149777
XL: How to Play a Warning Sound If Critical Value Is Exceeded

You can use the calculate event possibly to detect the change.

see Chip Pearson's page on events:
http://www.cpearson.com/excel/events.htm

 

[Bob Phillips]

Tom,

FYI, that KB item doesn't seem to be there anymore, nor any like it.

Regards

Bob

 

[Tom Ogilvy]

Damn the bad luck!

http://support.microsoft.com/default.aspx?scid=kb;en-us;213777
XL2000: How to Play Sounds Using Visual Basic for Applications


http://support.microsoft.com/default.aspx?scid=kb;en-us;86281
HOWTO: Play a Waveform (.WAV) Sound File in Visual Basic
[Contains the Constants for the Arguments]


Gives the basics.