Populate userform spreadsheet

[Alberto Ast]

I have inserted a spreadsheet into my userform...
how do I populate it from an excel sheet?

I have an excel sheet with advance filters so after I run the filters I put
the result into a new sheet... I want this info to be loaded into my userform
spreadsheet?

What do I need to do?

Thanks,
AA

 

[joel]

You need tot copy using the clip board. Direct copying doesn't seem t
work. to use the clipboard first copy then paste. Try this

Set Dest = UserForm1.Spreadsheet1.Range("a1")

Sheets("sheet1").Range("A1:B2").Copy
Dest.Past