Worksheet Change not firing

Can anyone shed some light on why this code won't work for me? Worksheet Change doesn't seem to fire when P3 becomes "13" or "43". It seems to work with Workbook Sheet Selection Change, but then the msgbox keeps popping up every time I click a cell/button after 13 or 43 is within the cell, I only wish for the msgbox to appear once.

Please Login or Register  to view this content.

Please note I have also tried Worksheet Calculate and this doesn't do anything either. I'm not getting any error messages or debugs.

Application.EnableEvents = 0
put before the end of the code. If it is not firing, one way would be to re-start your PC(I know it is pain in the neck, but always do this way) and events would be then enabled.

OK so I changed my code to:

Please Login or Register  to view this content.

And I restarted my PC, but it still doesn't work?

I have the code in Sheet1, is this correct?

Could it be because P3 is a formula? (=sum(Q3:X3)) and the sum only gets generated once the value of F3 is input. I would then expect the msgbox to show up after the value of F3 has been input by the user, but so far I do not have this working.

I have just tried your code also Holger, but this does not work for me. I think because you are inputting the value manually.

I did try the calculate event but that did not seem to work either. I have also tried referencing the sum range instead of the target cell but that also didn't work.

Rachel,
I did not notice on your code that your events should be the other way round. First False, or 0 and before the end it should be true, or 1

Can I ask what the immediate window is?

Also, AB33, I switched them like you said, having false first and true after my code and that did not work either.

Holger,
Look at your code no 4 and look again on Rachel's original code. The events are not on the same direction

Holger,
You are right!
It was my mistake. Was meant to be 1

I'm totally confused with this now and still do not have working code.. This is what I currently have...

Please Login or Register  to view this content.

Nevermind.. I started from scratch and this has worked for me..

Please Login or Register  to view this content.