VBA (Excel) Sub Routines

Using VBA (Excel)I am unable to run a sub routine which is called from another sub routine. I receive an error message saying the the sub routine i am calling cannot be found.

How can i automatically update the data a user inputs and as a resultautomatically rerun the program-recalculating the data.I guess in a similar fashion to the way Excel automatically recalculates formulas.