having issues with target cell containing a formula (office 2000)

good afternoon. i am having some issues with the following line in VBA :

If Target.Address = "$E$120" Then Range("A5") = Range("A5") + Target.Value

my problem is that the value does not update in A5. i believe this is because there is a formula in E120. is this the case, and if so, is there a work around? this is part of an inventory tracking sheet, and the formlula in E120 only shows a result if it pertains to particular criteria, i.e.: used, received, damaged, cut wrong, etc.:. this method is working fine for other cells that have drop in values from the user form, but it doesn't seem to work at all for cells that update with a formula.


thank you for your kind assistance.