Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can i run a macro from a formula
i CREATED A VERY SIMPLE MACRO TO DELETE ROWS, BUT I WANT TO CALL IT WHEN
CERTAIN CONDITIONS ARE TRUE, IT IS POSSIBLE CALL A MACRO FROM A FORMULA? I THINK THAT IN LOTUS 123 THERE IS A COMMAND TO EXECUTE A MACRO SO SHOULD BE ONE IN EXCEL. THANKS |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can i run a macro from a formula
Fred,
Try this =<Function Name(D10,"=1000") Make your macro a function and place it in the formula in place of the <Function Name. "FRED" wrote: i CREATED A VERY SIMPLE MACRO TO DELETE ROWS, BUT I WANT TO CALL IT WHEN CERTAIN CONDITIONS ARE TRUE, IT IS POSSIBLE CALL A MACRO FROM A FORMULA? I THINK THAT IN LOTUS 123 THERE IS A COMMAND TO EXECUTE A MACRO SO SHOULD BE ONE IN EXCEL. THANKS |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can i run a macro from a formula
What JRForm is talking about is a user defiend function (or UDF) which can
only return a value to the cell that it is in. It can not delete other cells or rows or change formating or... It can ONLY return a value. So I don't think that is going to work out for you. A better option would probably be event programming. After the user has enetered a value (the event) code will automatically be executed to check the conditions and take the appropriate actions. Here is a link to get you started... http://www.cpearson.com/excel/Events.aspx -- HTH... Jim Thomlinson "JRForm" wrote: Fred, Try this =<Function Name(D10,"=1000") Make your macro a function and place it in the formula in place of the <Function Name. "FRED" wrote: i CREATED A VERY SIMPLE MACRO TO DELETE ROWS, BUT I WANT TO CALL IT WHEN CERTAIN CONDITIONS ARE TRUE, IT IS POSSIBLE CALL A MACRO FROM A FORMULA? I THINK THAT IN LOTUS 123 THERE IS A COMMAND TO EXECUTE A MACRO SO SHOULD BE ONE IN EXCEL. THANKS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula or Macro | Excel Worksheet Functions | |||
Formula in macro causes macro to fail | Excel Programming | |||
Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
formula to a macro help PLEASE | Excel Discussion (Misc queries) | |||
Macro Formula | Excel Discussion (Misc queries) |