Paste copied cell range into multiple userform textboxes

Hi
Is there a way to paste a copied cell range into multiple userform textboxes?

The copied cell range comes from different other workbooks.

Example: I have copied cell range a1:a5 and want to paste it into textboxes 1 to 5 in Userform1.

Is this possible?

if you put the copied range into an array you can access that array to fill your texboxes.
It all depends on how you access your other workbook.

the other workbook and the cell range is opened and copied manually.

Try this one.
Open sample workbook. Copy range from other workbook - Open UserForm and click CommandButton.

Perfect!! But what if the cell range that is copied is a1:e1?

Enyone know if the same thing can be done if the range copied is a1:e1?

This is a really old thread, but I was trying to find this exact answer and I needed to copy a row of cells, not a column of cells.

Using the work done by Bakerman2, here's how I reworked it to do that and to determine "row" or "column" of data. Just copy this code and replace the original code in Bakerman2's file.

This example is only for a single row of cells OR a single column of cells, not both at the same time.

Hope this helps someone out!
Uncle Rogi

Please Login or Register  to view this content.