Load Textbox from Sheet? 1

[daseffects]

I'm looking to load a range of text values from a sheet into a textbox on a userform. Am I even close w/ the below?

Private Sub Userform_initialize()
Load UserForm1
Userform1.Textbox1 = Range ("Sheet1!A1:A3&quot
End Sub

I do not want the userform to over write the range. Looking for just a one way fill.

David

 

[SkipVought]

Hi

You have 3 cells. That's 3 values. Are the supposed to be concatinated?

With worksheets("Sheet1")
  Userform1.Textbox1 = .[A1] & .[A2] & .[A3]
end with

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[daseffects]

Thanks for the quick reply.

It does the job