Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run a Macro inside a formula
I would like to know if it possible to run a marco inside a formula. I am
looking to put a formula together that uses a "If" statement, that if true it would run a marco? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run a Macro inside a formula
You can use a worksheet event macro to run when the result of a cell's
calculation meets a criteria. See: http://www.mvps.org/dmcritchie/excel/event.htm -- Gary''s Student - gsnu200791 "crash20001" wrote: I would like to know if it possible to run a marco inside a formula. I am looking to put a formula together that uses a "If" statement, that if true it would run a marco? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run a Macro inside a formula
Formulas can not run macros, it's a limitation by design. You might instead
have a look at the worksheet_change event macros in the sheet module or thisworkbook module, they run on cell entries. HTH. Best wishes Harald "crash20001" wrote in message ... I would like to know if it possible to run a marco inside a formula. I am looking to put a formula together that uses a "If" statement, that if true it would run a marco? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run a Macro inside a formula
I am having issues with the event marco location. Is it in the VB code or in
Excel? "Harald Staff" wrote: Formulas can not run macros, it's a limitation by design. You might instead have a look at the worksheet_change event macros in the sheet module or thisworkbook module, they run on cell entries. HTH. Best wishes Harald "crash20001" wrote in message ... I would like to know if it possible to run a marco inside a formula. I am looking to put a formula together that uses a "If" statement, that if true it would run a marco? Thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run a Macro inside a formula
It is VBA code and all VBA code is a part of the file in which it resides.
HTH Otto "crash20001" wrote in message ... I am having issues with the event marco location. Is it in the VB code or in Excel? "Harald Staff" wrote: Formulas can not run macros, it's a limitation by design. You might instead have a look at the worksheet_change event macros in the sheet module or thisworkbook module, they run on cell entries. HTH. Best wishes Harald "crash20001" wrote in message ... I would like to know if it possible to run a marco inside a formula. I am looking to put a formula together that uses a "If" statement, that if true it would run a marco? Thanks |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run a Macro inside a formula
Rightclick the sheet tab, "view code", and you should be able to create it
with the two dropdowns just above the big white module area. And then ThisWorkbook is found in the project explorer to the left. Best wishes Harald "crash20001" wrote in message ... I am having issues with the event marco location. Is it in the VB code or in Excel? "Harald Staff" wrote: Formulas can not run macros, it's a limitation by design. You might instead have a look at the worksheet_change event macros in the sheet module or thisworkbook module, they run on cell entries. HTH. Best wishes Harald "crash20001" wrote in message ... I would like to know if it possible to run a marco inside a formula. I am looking to put a formula together that uses a "If" statement, that if true it would run a marco? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I run a macro from inside an"=IF" formula in Excel 2003? | Excel Worksheet Functions | |||
Event Macro running another macro inside | Excel Discussion (Misc queries) | |||
using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
Macro Inside Cell | Excel Discussion (Misc queries) | |||
Need macro to insert text string while inside cell (formula) | Excel Discussion (Misc queries) |