Whitty
08-07-2007, 10:48 PM
I have a fairly extensive user form that will gather data from a user then display a lot of analysis of that data. So a majority of the text boxes will simply display the results of formulas run in the worksheet based on the data that is inputted. I learned how to link a text box to the cell using ControlSource, but that did not solve my problem.
The problem is that when I put a formula into the cell linked to a text box in the user form, the formula runs right after I input it (like it normally would) but then the formula is overwritten with the results. So I can not pre-program all of the formulas and then run the form as all of the formulas are gone.
I'm at a loss. Please help! :help
The problem is that when I put a formula into the cell linked to a text box in the user form, the formula runs right after I input it (like it normally would) but then the formula is overwritten with the results. So I can not pre-program all of the formulas and then run the form as all of the formulas are gone.
I'm at a loss. Please help! :help