Getting a macro/sub function to run automatically when values change

[jpe1]

Hi Guys,
Is it possible to get a code to run automatically if any of the value change. I have attached a copy of a code I have. So for instance if I run the code the table will fill itself in. However I want to know if I change any of the values in B2:B4 is it possible for the table to automatically update?

[romperstomper]

Right-click the sheet tab, choose View Code and paste this in:

Please Login or Register  to view this content.

Note that you have a superfluous End If in the Mass_percent routine so it won't currently work. Remove the one before the End Sub.

[KOKOSEK]

Into Sheet1 code (not tested):

Please Login or Register  to view this content.

[jpe1]

Thanks guys, both codes work perfectly