Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
display worksheet on form
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
display worksheet on form
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
display worksheet on form
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" 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
to display content of worksheet on a user form in visual basic | Excel Programming | |||
display contents of a worksheet in a form/frame | Excel Programming | |||
Display Worksheet image on a form | Excel Programming | |||
Display Worksheet image on a form | Excel Programming | |||
Display data in form from worksheet using Filter | Excel Programming |