Userform Button:copy string from one textbox to another

**wali** · 07-23-2010, 05:16 PM

Hello,
I have a userform which I use as dictionary editor for a large wordlist (in worksheet "List 1"). Now I want to copy and paste the string from one textbox to another if the button "convert" is pressed. Pressing the button should not only copy and paste from one textbox to another but also convert the letters of the pasted string into other symbols according to the table in worksheet "conversion-table". The symbols of column A should be converted into symbols in Column B in ws "conversion-table", if the button is clicked.

The name of the source texbox from which the string has to be copied is in worksheet "conversion-table" in D2. The name of the target textbox where the string has to be pasted is in ws "conversion-table" in E2.

I will be very thankfull if someone could help me with it.

P.S. I had mentioned this problem in another thread as well but it is not yet solved: http://www.excelforum.com/excel-prog...-to-table.html

**royUK** · 07-24-2010, 01:27 AM

I can only see part of your userform on my screen - it's too big!

**wali** · 07-24-2010, 04:53 AM

Hi RoyUK,

I am posting a samller version of the userform and hope that now you will be able to see the whole userform on your screen.

**wali** · 07-25-2010, 05:46 AM

Hi,

can some one rewrite the following code to adjust it to my userform so that when i click on button "convert" that it copies the active cell in the userform to another cell and converts it:

Please Login or Register  to view this content.

source: http://www.excelforum.com/excel-prog...2nd-sheet.html

What has to be change in the code would be the range of the cells and that not the original cell is converted but that the singel active cell in the form is copied to another column and converted after that. Secondly that it happens only if the button is clicked.