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

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

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