I have manage to sort the problem by adding the following code in sheet2. As
the value in cell "j187" changes it changes tha value in textbox9.

Private Sub Worksheet_Calculate()
Application.ScreenUpdating = False
Sheets("Sheet2").Range("j187").Copy
Sheets("Sheet2").Range("j188").PasteSpecial Paste:=xlValues,
Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Application.CutCopyMode = False
End Sub

"hoyos" wrote:

I am trying to link a textbox to a cell that has a formula. Ideally the value
of the textbox changes everytime the value of the cell changes. But the
problem I am having is the the cell has a formula which get erased every time
the value changes.

The cells(J187) formula is as follows: =SUM(J69:J186)
TextBox9 displays the value of cell "Sheet2 J187"
I need it to change as cell J187 changes.
Any ideas