Can I call a macro from an if statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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(),"")
 
Frank,

Thanks for your help.

Jim
-----Original Message-----
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(),"")


--
Regards
Frank Kabel
Frankfurt, Germany


.
 
Back
Top