Display sheet in userform

[ApolloID]

Hi, can a macro display the content of a sheet in an userform?
I have excel 2007.

Can this be done?
Thanks!

 

[Domski]

If you right click on the Userform Toolbox and select Additional Controls you can choose a Spreadsheet control to add.

Dom

 

[ApolloID]

I tried, but in 2007 there is no such control.

 

[mancubus]

hi,

look for:
microsoft office spreadsheet 10.0
microsoft office spreadsheet 11.0

 

[ApolloID]

Hi, i found microsoft office spreadsheet 11.0 and now it,s working.
I am using this formula:

Private Sub UserForm_Initialize()
Me.Spreadsheet1.Cells.Range("A1:Q43").Value = ThisWorkbook.Worksheets("Sheet2").Range("A1:Q43").Value
End Sub

It,s ok, but it's not keeping sheet's format.

Can this be done?
Thanks!

 

[Domski]

You could copy and paste:

Private Sub UserForm_Initialize()

ThisWorkbook.Worksheets("Sheet1").Range("A1:Q43").Copy

Me.Spreadsheet1.Cells.Range("A1").Paste

End Sub

To be honest I've never really thought of a good reason for using a worksheet control in a userform so don't know much about the limitations of them.

Dom

 

[ApolloID]

Perfect!
Thanks!!!