spreadsheet 10 control

[ProteanBeing]

I put a spreadsheet control into a userform. How do I move data into it using VBA code?

[qff]

Hi

this is one way you could do it

Private Sub UserForm_Initialize()
Spreadsheet1.Sheets(1).Select
Dim myrow As Long
Dim mycol As Integer
For myrow = 1 To 5
For mycol = 1 To 7
Spreadsheet1.Cells(myrow, mycol).Value = Sheet1.Cells(myrow, mycol).Value
Next mycol
Next myrow
End Sub