TextBox in UserForm to show cell value instantly

**gsandy** · 11-03-2009, 06:17 PM

I thought if I did that then if anyone types anything in the third TextBox it would overwrite the formulas in the linked cell?

Thanks Sandy

**D_Rennie** · 11-03-2009, 06:21 PM

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

Private Sub txbox_Enter()
TextBox1.SetFocus
End Sub

**gsandy** · 11-03-2009, 06:40 PM

Did that, and whether enabled is set to true or false, the formula in the cell is overwritten when I start entering values in the first two TextBoxes (there are no links in theses two TextBoxes)??

**Leith Ross** · 11-03-2009, 06:50 PM

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

**gsandy** · 11-03-2009, 07:24 PM

Hi Leith,

The problem with your solution is that you have the calculation within "ShowSum". The answer showing in my cell B11 comes from quite complex spreadsheet calculations and I dont think I can do this within VBA.

Is my best solution to have a "Calculate" command button that refreshes the form to show B11's cell value?

Thanks Sandy

**Leith Ross** · 11-03-2009, 09:24 PM

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.