Copy and convert symbols from active Col. A cell to Cell in Col.B

[wali]

Hello,

I have a userform "SmallQform" which I use to edit my excel worksheet "List 1". Textboxes in userform are connected to cells in "List 1". Now I want to copy the current/active cell from col. A to the cell of col. B, if the button "convert" is clicked. Clicking the button should not only copy from Col A to Col. B but also convert the symbols of the pasted string in the cell of Col. B. The conversion should be done according to the list in worksheet "conversion-table".

I already have a macro which does conversion. But it converts the whole column A. May be it can be modified to solve the current problem.

Please Login or Register  to view this content.

I will be thankful for each help.

[Palmetto]

Now I want to copy the current/active cell from col. A to the cell of col. B, if the button "convert" is clicked

This makes the column-B cell, on the same row, equal to the value of the cell in column-A.

Please Login or Register  to view this content.

[wali]

Dear Palmetto,

thank you very much for your help. The problem is now solved. I added following code to the button and its working:

Please Login or Register  to view this content.