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


.
Click to expand...
 
You must log in or register to reply here.

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

Run Macro If Cell have "x" value 0
IF Statement 0
Call Macro 2
If Statement to run a macro 4
Search OF Macros for a specific phrase 2
Nested IF statement 3
Create Macro to pull data from a warehouse management system? 1
Macro to If Statement 7

Back
Top