Detect Value change of a Cell
 

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

Detect Value change of a Cell
 

http://support.microsoft.com/default...b;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

--
Regards,
Tom Ogilvy

"Stone" wrote in message
...
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

Detect Value change of a Cell
 

Tom,

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

Regards

Bob


"Tom Ogilvy" wrote in message
...
http://support.microsoft.com/default...b;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

--
Regards,
Tom Ogilvy

"Stone" wrote in message
...
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