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.