Actually, there is another way, which is to place a spreadsheet
right on the form. The title bar and row and column headings can be
hidden if desired. Right-Click in the toolbox and select additional
controls and look for Microsoft Office Spreadsheet xx.y. Then you
can do stuff in the form's code like:

Me.Spreadsheet1.Range("A1:J10").Formula = _
ThisWorkbook.Worksheets("Sheet1").Range("A1:J10").Formula

The only thing is, since upgrading to Office XP 2003, I get a nasty
ActiveX warning message when doing this. Otherwise it works great.
Does anybody know how to avoid the message? I searched on this, but
most people said nothing they tried worked.