Hello All

I was curious whether it is possible to display the top row of a worksheet
in a multipage tabbed control or even the worksheet if that is easier. Is
this possible.

Thanks

Jake

There is a Microsoft Office Spreadsheet control that can be added to a
user form. You should be able to find it in "Additional Controls" accessed
by right-clicking the Toolbox. I have played around with it, but never "used"
it in an application.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Jakem Schott"
wrote in message
Hello All
I was curious whether it is possible to display the top row of a worksheet
in a multipage tabbed control or even the worksheet if that is easier. Is
this possible.
Thanks
Jake

Private Sub UserForm_Initialize()
ThisWorkbook.Sheets(1).Range("A1:G20").Copy
Spreadsheet1.Sheets("Sheet1").Range("A1").Paste
Application.CutCopyMode = False
End Sub
--
Jim Cone
San Francisco, USA


"Jakem Schott"
<(E-Mail Removed)>
wrote in message
Thanks Jim
I had seen that but was unsure how to get the current activeworkbook sheets
into it, I was hoping to see an example if some one had one.
Thanks
Jake

"Jim Cone" wrote:
> There is a Microsoft Office Spreadsheet control that can be added to a
> user form. You should be able to find it in "Additional Controls" accessed
> by right-clicking the Toolbox. I have played around with it, but never "used"
> it in an application.
> --
> Jim Cone
> San Francisco, USA
> http://www.realezsites.com/bus/primitivesoftware

>
>
> "Jakem Schott"
> wrote in message
> Hello All
> I was curious whether it is possible to display the top row of a worksheet
> in a multipage tabbed control or even the worksheet if that is easier. Is
> this possible.
> Thanks
> Jake
>