Run macro via cell value
 

Is it possible to run a macro based on the value of a cell. Say for example
A1 contains the word "run" can that word be the trigger to automatically run
a macro?

Pat

Hi Pat

A worksheet formula can not trig a macro. No way.

But a worksheet has several events; macros that run when certain things
happen. There is an event firing when you enter something into a cell,
another when the sheet recalculates, ... see
http://www.cpearson.com/excel/events.htm for more on this.

HTH. Best wishes Harald

"Pat" skrev i melding
...
Is it possible to run a macro based on the value of a cell. Say for
example
A1 contains the word "run" can that word be the trigger to automatically
run
a macro?

Pat

That answers that!
thanks Harald

Pat
"Harald Staff" wrote in message
...
Hi Pat

A worksheet formula can not trig a macro. No way.

But a worksheet has several events; macros that run when certain things
happen. There is an event firing when you enter something into a cell,
another when the sheet recalculates, ... see
http://www.cpearson.com/excel/events.htm for more on this.

HTH. Best wishes Harald

"Pat" skrev i melding
...
Is it possible to run a macro based on the value of a cell. Say for
example
A1 contains the word "run" can that word be the trigger to automatically
run
a macro?

Pat