View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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