Thread: If statements and macros
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_684_] Leith Ross[_684_] is offline
external usenet poster
  
Posts: 1
Default If statements and macros

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

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=56400

Reply With QuoteReply With Quote