Auto tabbing between textboxes in userform with paste

[phagan]

I'm trying to set up a set of text boxes in a userform that people will be pasting into from a range of cells there will be variable lengths of data pasted into each textbox. The only definate bit is that the data from each cell is separated by a space character. So the Question is. How can I set up the Form so that when someone is pasting the data it autotabs to the next text box when it sees the space between the data? I was going to trim the data to get rid of the spaces if they were still pasted in.

 

[phagan]

I guess people aren't understanding this. The information that will be pasted will look like this:

0.0401 0.0031 0.0219 0.4403 0.8721 16.0428 4.3708 0.1873 3.0875 0.0005

Into 10 Corresponding text boxes. This is so that the Data can be analysed and then put into a spreadsheet.

The issue is that the user should not have to individually past each bit of that into each textbox. I want to get rid of the 10 individual copy and paste operations that would be needed to do this.

I have looked everywhere and have been unable to find what I am looking for.

 

[phagan]

Can anybody help me with this please? This issue has become a show stopper for me.