automatic update for cell in worksheet using vba doesnt want to display value

Hi this code doesnt want to display my value in n12 dependant on the change in m12 on the same worksheet. help plz

Please Login or Register  to view this content.

Thanks for complying. Change:

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

and you should be fine.

Misread your code - you want the change event, not the selection change event. Change the first line to:

Please Login or Register  to view this content.

Are you changing M12 manually or as the result of a formula? If the latter, then a change event won't work and you'll need the Worksheet calculate event.