Auto Refresh textbox in userform on cell change

[HKB]

Hello...
I want code where the textbox in my userform = E250.
How do I get this so that each time E250 changes the textbox refreshes if it is open,
WITHOUT having to click a button or close out and reopen the userform.
Basically userform will stay open and real time reflect cell E250.

I have above code in my UserForm Initialize.

Private Sub UserForm_Initialize()

    TextBox1.Text = Sheets(1).Range("E250").Value
   
End Sub

Thanks!

 

[NARAYANK991]

Hi ,

I have not understood what your requirement it , but it seems to me that you can use the Worksheet_Change event procedure to transfer data from the cell E250 to the textbox.

Narayan