Updating Textbox in Form

[zedutch]

I have a textbox in a form in Excel that is linked to a cell on the main sheet. This cell is continuously updating on the sheet but the textbox does not update. Is there a way to continuously refresh the value in the textbox?

- Eric

 

[PHV]

What is the value of the ControlSource property of the textbox ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[zedutch]

I simply have: txtInAmpsA.Value = Cells (15,15)
On the main sheet, Cell(15,15) updates regularly but on the form, the textbox remains as it was when I first opened the form.

 

[zedutch]

Is that what you were asking?

 

[fumei]

Sheet_Change event? This will only work if the userform has SystemModal = False. Otherwise focus would remain with the userform.

Why are you using a textbox? Is the user actually going to be entering data into it? If it is just displaying data - ie. no actual user input - then use a Label.

In the userform:

Sub UserForm_Initialize()
   Label1.Caption = Worksheets("Sheet1").Cells(1, 1).Value
End Sub

In the Sheet module:

Sub Worksheet_Change(ByVal Target As Range)
   UserForm1.Label1.Caption = _
        Worksheets("Sheet1").Cells(1, 1).Value
End Sub

If the userform is SystemModal = False, and the cell value is changed, the new value immediately updates the label on the userform.

I am probably doing it wonky, but then...I am not an Excel guy.

Gerry
My paintings and sculpture

 

[PHV]

What about this ?
txtInAmpsA.ControlSource = "O15"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[zedutch]

Fantastic! Thanks both of you!