Clear Content When a cell value = 0

Hi,
I have a sheet that I need to clear contents on a range of cells in 1 worksheet when a specific cell = 0 on another worksheet but it just is not working and I can't see what the problem is and hoping a fresh pair of eyes can help?

Here is my code:

Please Login or Register  to view this content.

I know the Reset_Fields part works as it performs perfectly when I call it using the "Run" button so the problem seems to be calling it, maybe Value =0 is incorrect?????

Any pointers greatly appreciated
Thanks

Welcome to the forum. Please, read forum rules and use CODE tags around your code.
The code looks OK, so I assume it's a problem where, i.e. in which Sheet Module/Module, this one and Reset_Fields are. Can you upload sample workbook.

The reason is that worksheet_change is not triggered when the cell changes as result of calculation. From the help:

Remarks
This event doesn't occur when cells change during a recalculation. Use the Calculate event to trap a sheet recalculation.