TextBox in UserForm to show cell value instantly

I have two TextBoxes (txtSpan & txtTrib) in a UserForm (frmSizes), when values are entered in these TextBoxes they show (as they are typed) in cells of the spreadsheet. The resulting calculation is in cell B11.

How do I get the value in cell B11 to show in a third TextBox (txtAns) as soon as it is calculated without closing the UserForm or running another code?

Thanks Sandy

if you have used the control source proptie on the textbox's it textbox will update automatically on the exit event of the 1st two texoboxes

ot in other words set the trd textbox control source to B11

true though if the purpose of the txbox is to display results could you not set the enabales to false

actially you can not set the enabled to false else the data will not update
try setfocus

Please Login or Register  to view this content.

Hello Gsandy,

The attached file should help. It uses three text boxes to sum 2 values and display the results in the third. All values are shown in cells "A1:C1".

Hello Gsandy,

The button might be the way to go. With so little information about the layout, data, formulas, and VBA code, I can't give you an definitive answer.