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).

