in VBA code yes you can initate a macro using a If statement. Jus
substitute the name of your macro for MyMacro in the example. The macr
can be run at anytime in VBA simply by placing the macro's name, and an
arguments required in your code.
Example:
If condition = True Then
Call MyMacro
End If
If Range("A1").Value = 1 Then
Range("C1").Interior.ColorIndex = 3
Else
Range("C1").Interior.ColorIndex = 5
End If
(though you wouldn't need a macro for this)
--
Regards,
Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows] http://www.microsoft.com/protect
:
| Is it possible for an "if" statement to initiate a macro?
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.
