Can I start a macro from a cell by using a formula

P

PraxisPete

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?
 
A

Arvi Laanemets

No

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change a great number of words in word files, with a macro as short as possible. 5
Word macro that can call cells out of Excel for a find and replace 0
Hide columns based on row values 2
Drop down list control value in vba 2
Need Help with Macro Security 1
Logical Test 5
value_if_false returns formula 0
#NAME? error in nested if & VB 3

Top