| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to look for empty cell | Excel Discussion (Misc queries) | |||
| Can I start a macro from a cell by using a formula | Excel Worksheet Functions | |||
| Syntax for inferred cell references | Excel Worksheet Functions | |||
| A Macro that will cut and paste to specific cell | Excel Discussion (Misc queries) | |||
| show macro security setting in a cell | Excel Worksheet Functions | |||
Linear Mode
