Private Sub Userform_Initialize()
With Worksheets("Sheet2")
Textbox1.Text = .Range("A21").Value
Textbox2.Text = .Range("B9").Value
Textbox3.Text = .Range("M32").Value
Textbox4.Text = .Range("Z1").Value
Textbox5.Text = .Range("F10").Value
End With
End Sub

Goes in the Userform code module

--
Regards,
Tom Ogilvy

"stck2mlon " wrote in message
...
Ok, continuing on with my VBA Tutorial...

I have a row with 5 cells that have something in each one. I want to
take those 5 cels and populate 5 text boxes. I have created a userform,
where do I begin to pull the information from the current worksheet?


---
Message posted from http://www.ExcelForum.com/