Can I put a List of cells into a UserForm Textbox and have the list assigned a cell value?

I would like to take a List of numbers, which come from a separate spreadsheet, place them into a UserForm text box and then use a command button to input the
list of numbers into a column of cells. The list would often vary, between 1 and 10 entries. But if I could do this, I would be able to resolve an issue with my spreadsheet that continues to haunt me (the dreaded number stored as text.....). I know that you can assign a single textbox value to a single range-cell value. But if I could input a list at a time, it would obviously save a lot of effort.

Example

In spreadsheet #1, I would copy the list below.


25466
87550
66985
44252

In the user form I would paste these numbers into the text box and they would be input into Sheet #2

B6 = 25466
B7 = 87550

etc. etc.

Any other suggestions would be helpful, but if this system would work, I would be greatly appreciative.

Basically, I get spreadsheets from an analyst with a list of numbers in it - (cells C2-C10) For whatever reason, they are numbers formatted as text. I was thinking that if I copy this list and paste the number list into a userform textbox, then use the code to populate my column of cells (B6-B16), it would eliminate the need for the pasteSpecial multiply trick. Thereby, I would avoid having an extra step.

Thanks!