Is there a command to run a macro as the condition for TRUE in an I
statement

--
bhaloonee
-----------------------------------------------------------------------
bhalooneel's Profile: http://www.excelforum.com/member.php...fo&userid=2402
View this thread: http://www.excelforum.com/showthread.php?threadid=37638

Could you tell where is the IF statment located? in a Cell or in
Macro? it depends...

bhalooneel Wrote:
Is there a command to run a macro as the condition for TRUE in an I
statement

--
jose lui
-----------------------------------------------------------------------
jose luis's Profile: http://www.excelforum.com/member.php...fo&userid=1331
View this thread: http://www.excelforum.com/showthread.php?threadid=37638

It's in the cell.


--
bhalooneel
------------------------------------------------------------------------
bhalooneel's Profile: http://www.excelforum.com/member.php...o&userid=24023
View this thread: http://www.excelforum.com/showthread...hreadid=376381

bhalooneel Wrote:
It's in the cell.

1. Put your IF in the cell
2. Label the cell (lets say SwCell)
3. put your macro in the Worksheet.Calculate. Something like



Code:
--------------------
If Range("Condition onSwCell") Then
Your Code
Else
your code
End If
--------------------


4. Pull the result of the Cell to your Macro with Range("Condition
onSwCell")


Your Macro will run every time the worksheet is calculated, if it in
automatic calculation, always will be testting your condition and doing
your code.


Hope this helps

Regards

Jose Luis


--
jose luis
------------------------------------------------------------------------
jose luis's Profile: http://www.excelforum.com/member.php...o&userid=13312
View this thread: http://www.excelforum.com/showthread...hreadid=376381