Jason_S
03-27-2017, 02:39 PM
I have a userform in which is a text box that contains text consisting of, say, 9 or 10 sentences of text. The user makes a few selections on the user form, and then the text from the text box is copied to the clipboard, and the user form is unloaded and hid.
What I need: For the text that now lives in the clipboard, I need highlighted yellow certain words BEFORE the user presses PASTE and dumps the text into the Word Document.
For an easy example, if the Userform's Textbox's text was "The Quick Brown Fox Jumped Over The Lazy Dog", and the user clicked Userform command button "Copy to clipboard" (which button also hides/unloads the user form), then when User selects insertion point in document and presses PASTE, the word "Brown" (and only the word Brown) would be highlighted yellow when pasted.
In effect, I need to format the text when it resides in the clipboard and then paste it as formatted text. I cannot use a modeless user form (in MAC environment where modeless user forms are not supported). Any ideas?
What I need: For the text that now lives in the clipboard, I need highlighted yellow certain words BEFORE the user presses PASTE and dumps the text into the Word Document.
For an easy example, if the Userform's Textbox's text was "The Quick Brown Fox Jumped Over The Lazy Dog", and the user clicked Userform command button "Copy to clipboard" (which button also hides/unloads the user form), then when User selects insertion point in document and presses PASTE, the word "Brown" (and only the word Brown) would be highlighted yellow when pasted.
In effect, I need to format the text when it resides in the clipboard and then paste it as formatted text. I cannot use a modeless user form (in MAC environment where modeless user forms are not supported). Any ideas?