Assigning values

[Azarudeen]

Hi All,


I have a excel like below in the C column and D column


C D

ا A
ء A
ب B
ت T
ث TH
ج J
ح H
خ KH
د D
ذ DH
ر R
ز Z
س S
ش SH
ص S
ض D
ط T
ظ Z
ع A
غ GH
ف F
ق Q
ك KH
ل L
م M
ن N
ه H
ة H
و W
ي Y
ى Y
لا LA
ال AL




I want to write a macro that whenever I type ا this needs to be changed to A in the column A and B.
If I change/add anything in C column, it should work.


Can someone help me on this.

 

[MickG]

I know it not very good but you have to enter a letter then click somewhere in the sheet , the results should show , then you can repeat the same procedure to obtain more letters.
I realize its pretty rubbishy, I thought it would give the thread a new "Bump" !!!!
I think it need a new approach !!!

 

[Azarudeen]

Yes Mick but the task is to get a input from excel and process..

The only problem with the current code is not combining the words and it works for only single letter.

Can someone help me in this scenario

 

[Azarudeen]

Is there any other method that will this issue..