Can I call a macro from an if statement

J

jpm3349

I want to run a macro from an if statement such as this

If(e1>f1, run macro, " ") - Is this possible

Thanks for you hel

Jim
 
F

Frank Kabel

Hi Jim
you can call as user defined function but not a sub procesure from a
formula
so if you have defined a function like
public function foo()
foo=1
end function

you can use
If(e1>f1, FOO(),"")
 
Top