Copy data from row and paste into user form

Right now I have four text boxes in a userform and I manually copy text from 4 cells into each text box. It would be nice if I could copy cells A1:D1 and "paste" the results into the text boxes all at once. It's ok if I have to use a "paste" button instead of the traditional ctrl+v.

I guess the real problem is after I copy cells in excel I don't know how to manipulate or use it in a useful way in vba. Is it stored as an array?

Hello
You can add a command button to your userform and add this code

Please Login or Register  to view this content.

Hello. Sorry this won't work in my case. The cells that I actually copy aren't in a static location. Sometimes it's a different worksheet or workbook. I was hoping to keep it flexible so I can find the data I need, highlight it, hit ctrl+c, then paste into the form.

Edit - I was able to find a solution but I need some help tweaking it/error handling.

The first issue is the last textbox always seems to carry some extra characters. For instance, if I copy 4 cells the last text box has a paragraph symbol. If I copy 4+ cells the last textbox is a combination of the 4th cell and the 1st cell of the 2nd row, with the addition of a paragraph symbol separating them. Is there a way to fix this so the last textbox only shows the valve of the 4th copied cell?

The second issue is the code breaks if I don't have at least 4 columns copied. I'm still not sure how I should be parsing the clipboard string. I would like to exit the sub if the array doesn't have at least 4 items.

Please Login or Register  to view this content.

Edit 2 - Okay I figured it out but it is a very crude method and there is definitely a better way.

Please Login or Register  to view this content.