Another note, just so you understand, the first macro was for text in the document, not text in a userform. I am confident that wiser heads than I can adjust for that, but it is a different thing.

If I were doing it, I would need to create a new document, put the text in that document, and then run the code. Then copy the reformatted text from the temporary document, delete that document, and put it in the userform.