Thanks Duncan once again. You are correct that the important text I'm trying to use will always be 11 characters in this format: XX0000-0000 . I've thought about trying to use the hyphen in the middle as an identifier w/ 6 characters to the left and 4 to the right and do some magical text parsing or splitting or whatever. I've never done any type of text manipulation so this will be new stuff. Do I have to make a new public sub for the text manipulation or can I put it under the Public Sub CommandButton1 stuff? There is really no way of me knowing what will be included with this text when a user pastes it in. Sometimes we copy stuff from an email, sometimes a word document, but most times it comes from an Access or Excel spreadsheet. That's why I the spreadsheet previously worked so well because each row essentially had a single quote and comma. You could type in: howdy Supper Time XX0000-0000 XX0000-0001 And it would put Howdy in like: [StID] IN ('Howdy', 'Supper Time', 'XX0000-0000', etc) and since it just wouldn't find the first to strings in the field, it wouldn't care and just move on. Furthermore, with the textbox I'm using now, I can't type in more than one line. It is a multiline textbox, but only if I paste more than one line. If I hit enter, it fires the button, and doesn't drop down to the next line/row which I would like it to. So there are several limitations I'm seeing with the textbox. And also there is no row count, so you can't see how many StID's have been pasted in there. But that is pretty unimportant in the scheme of things. I do thank you for you help and I'll keep working on this.
... View more
