View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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