If statements and macros

  • Thread starter Thread starter Guest
  • Start date Start date
Hello Bmorganh,

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

Sincerely,
Leith Ros
 
Sure

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?
 
Back
Top