Private Sub Userform_Initialize()
Me.TextBox1.Text = Worksheets("Actions").Range("E4").Text
End Sub

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Patrick Simonds" wrote in message
...
How do I initialize a userform so that TextBox1 contains the value of Cell
E4 of the worksheet named Actions?