Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Executing a macro from a cell
1. There is some way to make that excel, starting from a conditional
structure in a cell, execute automatically a macro??? Something like this: A B 1 2 1 =if(A2=1,macro1(),macro2()) |
#2
|
|||
|
|||
No, functions can return a value, they cannot change the format or run a
macro. You can use event code to do it, but not a worksheet function. -- HTH RP (remove nothere from the email address if mailing direct) "filo666" wrote in message ... 1. There is some way to make that excel, starting from a conditional structure in a cell, execute automatically a macro??? Something like this: A B 1 2 1 =if(A2=1,macro1(),macro2()) |
#3
|
|||
|
|||
Hi
No, impossible. This is a limitation by design. A macro could change the cell itself, the sheet, excel, and therefore mess up the original logic and the order of calculations. But Excel has several "calculate" events that you might use to create a simiular effect. HTH. Best wishes Harald "filo666" skrev i melding ... 1. There is some way to make that excel, starting from a conditional structure in a cell, execute automatically a macro??? Something like this: A B 1 2 1 =if(A2=1,macro1(),macro2()) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
show macro security setting in a cell | Excel Worksheet Functions | |||
Help Pls re macro cell address | Excel Discussion (Misc queries) | |||
Executing macro for all worksheet from a different worksheet | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions | |||
macro error at cell | Excel Worksheet Functions |