how do I automatically run a macro from the result of a cell

Help....

I am trying to do away with the need for buttons in my spread sheet, for
example
if the result of a cell is = 0 then I want it to automatically activate one
macro, if the cell value is greater than 0 then I want to activate a
different macro.

Thanks..

Have a loook a worksheet events on Chip Pearson's site:

http://www.cpearson.com/excel/events.htm

HTH

"Barrie Lewis" wrote:

> Help....
>
> I am trying to do away with the need for buttons in my spread sheet, for
> example
> if the result of a cell is = 0 then I want it to automatically activate one
> macro, if the cell value is greater than 0 then I want to activate a
> different macro.
>
> Thanks..
>
>
>