Hello all,

This question is to all the Sultans of Excel.....

I s there a way I can program a macro to auto run, subject to
condition being true...something like,

Whenever the condition, ---If Range("a1") = Range("a2")--- is true
specified Macro should run automatically

--
Warrior180
-----------------------------------------------------------------------
Warrior1800's Profile: http://www.excelforum.com/member.php...fo&userid=2551
View this thread: http://www.excelforum.com/showthread.php?threadid=38957

Hi

Look at the change event
http://www.cpearson.com/excel/events.htm

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("A1").Value = Range("A2").Value Then runmymacro
End Sub

Sub runmymacro()
MsgBox ""
End Sub



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Warrior1800" wrote in message
...

Hello all,

This question is to all the Sultans of Excel.....

I s there a way I can program a macro to auto run, subject to a
condition being true...something like,

Whenever the condition, ---If Range("a1") = Range("a2")--- is true a
specified Macro should run automatically.


--
Warrior1800
------------------------------------------------------------------------
Warrior1800's Profile: http://www.excelforum.com/member.php...o&userid=25518
View this thread: http://www.excelforum.com/showthread...hreadid=389570