Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import from spreadsheet
Hi,
By 'a sheet on the userform' , do you mean a Microsoft Office SpreadSheet control (Office Web Components) ? If so, assuming your userform's sheet is Spreadsheet1 and assuming you have a command button Commandbutton1: ' fill the sheet on userform from workbook data Private Sub CommandButton1_Click() 'Eg1: by setting the range value Spreadsheet1.Range("A1") = ThisWorkbook.Worksheets(1).Range("A1") 'Eg2: by copyoing from the source workbook and pasting to the ' spreadsheet on the userform ThisWorkbook.Worksheets(1).Range("A1:a10").Copy Spreadsheet1.Range("A1").Paste End Sub -- Regards, Sébastien <http://www.ondemandanalysis.com "Kjeldc" wrote: I have a userform with a spreadsheet on. I want to populate it with data from an other sheet in a workbook. Can someone help, please Regards kjeldc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import Spreadsheet into Access | Excel Worksheet Functions | |||
How can I import our logo into a spreadsheet? | Excel Discussion (Misc queries) | |||
Import data to a spreadsheet. | Excel Discussion (Misc queries) | |||
How import MSWorks spreadsheet to Excel | Excel Discussion (Misc queries) | |||
Import a spreadsheet | Excel Programming |