Macro not applying correct value until second attempt

Macro triggered by changing the values in N4

Please Login or Register  to view this content.

Code multiplies each value in Col E by N4, shows results in Col G, adjusts Outstanding Balances in Col I, and shows % invoiced in Col H (As there are no "Prior payments" in the example attached, Col H should match N4)

Problem:: % entered is not what comes out on first attempt. Have to enter it again.
E.g. Enter 3% in N4, Col H applies 100%, making Cols G and I incorrect. Enter again, Col H now shows correct values of 3%. and Cols G and I are correct).

Please Login or Register  to view this content.

Never had this before, and can't see where the "error" can be?

All solutions, suggestions and alternatives welcome as ever

Ochimus

@Kenneth

You should also set Application.EnableEvents = True and then False at end.

Should this not be the other way round?