hi, i have used a nice bit of code from this web site and managed to add a ms office spreadsheet control on to a form which displayed data from a worksheet.

this was the code i used:

Dim Rstr

Rstr = Sheets(1).UsedRange.Address

Me.Spreadsheet1.Sheets(1).Range(Rstr).Value = Sheets(1).UsedRange.Value

End Sub

the data is displayed on the form sheet 1 as on the worksheet.

my problem is that i cannot get the spreadsheet control to copy the format of the cells of the usedrange..

i am using excel 2002 and so have used the microsoft office spreadsheet control 9.0 and 10.0

i hope my question makes sense as this is the first time i have asked for advice online..

thanks in advance, lee