userform initialize

How do I initialize a userform so that TextBox1 contains the value of Cell
E4 of the worksheet named Actions?

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" <[email protected]> wrote in message
news:[email protected]...
> How do I initialize a userform so that TextBox1 contains the value of Cell
> E4 of the worksheet named Actions?
>
>