Yes you can do that but it would have to be in the worksheet calculate
event and you would have to specify a cell, range of cells or intersect
that the trigger should happen on!EXCELMACROS;168746 Wrote:
Hi guys,

I have a share file, I will like for a macro to run when a condition is
met,
for example, when =count(B7:F7) = 4 then macro kicks and run by itself

is that possible?

--
Thank you...


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=46739