Linking Texbox in Userform to cell removes formula

Hi all,

I have a text box TextBox6 which I want to link to cell C18 of worksheet named "Detail". Cell C18 as a formula within it & every time I run the userform it links to the cell once then removes the formula from cell C18. I have various formulas within the workbook & I want the userform to run in real time if you understand? i.e changing a combo box will change the value in C18.

Thanks,

Tony.

Hello,

No I require it to work the opposite way. I have certain a formula in cell C18 & I want the result to show in textbox6 on the userform. It shows once but then when I change the variables on the userform thus changing the value in cell C18 the formula disappears???

Originally Posted by tehneXus

Hi,

could you please upload a sample workbook which contains the userform?

Example attached.


When you change the Size & input a number into the text box called "Pressure" of the userform the values are copied to the sheet "Detail". In cell C18 of the sheet "Detail" there is a multiplication formula which multiplies the values copied from the userform. The result from C18 is then shown on the userform in textbox6 but as soon as you change any values on the userform it deletes the formula in C18. I want to have the userform open & be able to adjust the values while having a result show in the text box named "Torque" of the userform in real time if possible.

Hope I have explained this better?

Thanks,

Tony.