userform initialize

[Patrick Simonds]

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

[Bob Phillips]

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" <ordnance1@comcast.net> wrote in message
news:eSLTqBBuGHA.2172@TK2MSFTNGP05.phx.gbl...
> How do I initialize a userform so that TextBox1 contains the value of Cell
> E4 of the worksheet named Actions?
>
>