Run macro via cell value

P

Pat

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
 
H

Harald Staff

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
 
P

Pat

That answers that!
thanks Harald

Pat
Harald Staff said:
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
Click to expand...
 
Top