Does anyone know how to set an initial value on a text box? I want
to go to a specific place on my worksheet and get the value that will
be the initial value and put it into the form that the user will then
either keep or change.

I read a post saying to use a private sub_initialize in my userform
code section that excel created for me and I put this code into it but
the value of Loc never shows up in the actual userform when I run my
code.

Private Sub UserForm1_Initialize()
Dim Loc As Range
Set Loc = Worksheets("Internals").Range("B4").CurrentRegion
TextBox1.Text = Loc
End Sub

Thanks,
Chet