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..

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

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..