Import from spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Thanks sebastienm. Perfect. But also a little curius! I tryed the code in
Form_Initialize, that did not work. Can you tell me why?

"sebastienm" skrev:
 
This is not working for me... I got an error on the
Spreadsheet1.Range("A1").Paste
Click to expand...
any idea why?

I have Excel 2002 SP3
my userform spreadsheet is Microsoft Office Spreadsheet 9.0
 
This is not working for me... I got an error on the
Click to expand...

What is "Spreadsheet1"? What error do you get? As written,
Spreadsheet1 must be a variable typed Worksheet and then Set to a
particular worksheet. E.g,

Dim SpreadSheet1 As Worksheet
Set SpreadSheet1 = ThisWorkbook.Worksheets("Sheet1")

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]
 
Chip,

Thanks for your replay.... spreadsheet1 is a spreadysheet within a user
form...
Below reply from Sebastien back in 2006 kind of answer what I needed but
I got the error so it does not work as stated initially...
I want to paste data from a worksheet into a spreadsheet in a user form
so I can see some data with in my user form.


Chip Pearson said:
This is not working for me... I got an error on the
Click to expand...

What is "Spreadsheet1"? What error do you get? As written,
Spreadsheet1 must be a variable typed Worksheet and then Set to a
particular worksheet. E.g,

Dim SpreadSheet1 As Worksheet
Set SpreadSheet1 = ThisWorkbook.Worksheets("Sheet1")

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]





This is not working for me... I got an error on the
any idea why?

I have Excel 2002 SP3
my userform spreadsheet is Microsoft Office Spreadsheet 9.0
Click to expand...
.
Click to expand...
 
Back
Top