UserForm Initialization

[Patrick C. Simonds]

Sorry if this is a second post, but my reader said my original message was
no longer on the server.

In UserForm Initialization, is there any way to have TextBox4 always show
the value of cell A4?

 

[Mike]

TextBox4 .value = Worksheets("Sheet1").Range("A4").value

 

[Josh heep]

Sorry if this is a second post, but my reader said my original message was
no longer on the server.

In UserForm Initialization, is there any way to have TextBox4 always show
the value of cell A4?

Hrm, I couldn't see my reply to the original post so I am trying
again....

Private Sub UserForm_Initialize()

Me.TextBox1.Value =
ThisWorkbook.Sheets("Sheet1").Range("A4").Value
' Or
' Me.TextBox1.Value = ThisWorkbook.ActiveSheet.Range("A4").Value

End Sub