Problem with formulas turning into values.

[TIMOTHYs]

I have a VBA form that gets information from a worksheet and populates into the text boxes of the form using the control source property. Once I run the code, the formulas that were in the cells that the form gets its data from becomes the result of the formula and when I run it again the next day the numbers don't change because the value is yesterdays value and I have re-key the formula to make it work. I have no idea what is going on. It doesn't happen every time I use it but is becoming a nuisance to fix the formula when it does. Can any one help with this? (I hope this makes sense).

 

[Fluff]

I would advise against using the control source.
If you change the value in the control, that change will be reflected in you worksheet.
It would be better to remove the control & populate the textboxes when the form is initialised