Formula not triggering Routine

Hello
I found what I thought to be the most simple code for my use and it works a treat other than when the number in column two reaches a zero by way of a formula, the date called for does not appear in column 5 even though the cell is empty. When I enter a zero in column 2 manually, all is good. I have read that the formula change does not trigger the code and perhaps using calculate instead of change but without success.
Any ideas or solutions would be very much appreciated

Please Login or Register  to view this content.

.
This works here :

Please Login or Register  to view this content.

There were two PERIODS between TARGET & VALUE.

Thanks for the prompt reply and sharp eye. I tried again but without success. I put the following formula in column B and the edit the adjacent cell in column A
Again, no luck

=IF(A6=1,0,"")

It will work if the zero is entered manually.
Thanks again

Thanks. In this simple example that would be good but in the sheet I am using it in, the zero is generated from a range where varying amounts of cells could be changed for each row for instance, when the zero is met i.e. all required cells are complete.

I have updated the code for the attached workbook. As you can see, adding anything in the table to complete the row has no effect but entering a Zero in column J manually when J is empty has the desired effect.
Thanks

Not sure what's happening but I don't seem able to attach the workbook.

Hopefully attached this time???

Thanks SHG