Triggering value change in vba output on sheet two when input comes from sheet one

Hi,

I have a bit of code in sheet two of my document that requires user input to produce output. However I have the document set up in a vway that requires the actual input to be placed in a vell in sheet one, and the cell in sheet two is just "=cell in sheet one".

This causes the input cell in sheet two to change but the output cell does not produce the new answer.

Anyone know why?

Thanks in advance!