ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Can I start a macro from a cell by using a formula (https://www.excelbanter.com/excel-worksheet-functions/21127-can-i-start-macro-cell-using-formula.html)

PraxisPete

Can I start a macro from a cell by using a formula
 
Is it possible to enter a formula into a cell, and if the result returns True
then a macro runs? The Formula may look like this

=If(Logical_Test,[Call€¯MacroName€¯],[Value_if_False])

Can it be done if the result returns False?


Arvi Laanemets

No

For formulas/functions no activities are allowed - they only can display
information in cell, they are situated.

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"PraxisPete" wrote in message
...
Is it possible to enter a formula into a cell, and if the result returns

True
then a macro runs? The Formula may look like this

=If(Logical_Test,[Call”MacroName”],[Value_if_False])

Can it be done if the result returns False?





All times are GMT +1. The time now is 03:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com