Apply function to the data pasted into userform

[wali]

Hello,

i have an excel function which replaces a specific character according to a criteria. Now i want to make a userform where user can paste text and click the button. The text pasted from user in the textbox of the userform should then be processed.

Process:

1) convert the symbols of pasted text to:

Please Login or Register  to view this content.

2) After conversion apply following function to the text:

Please Login or Register  to view this content.

3) Reconvert the text to:

Please Login or Register  to view this content.

I am attaching an excel file where it works fine. But i want to do this job through userform.

I will be thankful for each help

[Leith Ross]

Hello wali,

You should let people know that you are using Pashto in the workbook. Not everyone may have the needed language pack loaded to view this properly.

[wali]

Dear Leith Ross,
you are right. I should have mentioned that because one needs to activate "right to left" languages in "regional settings" in windows. That way one can view the pashto letters I have used in example file.

Here is a link where it's explained how to install the complex languages support in windows:

http://www.microsoft.com/resources/d....mspx?mfr=true

thanks