I think you can do it like this
- Code: Select all
Sub script()
Text2.Text = Replace(Text1.Text, "a", "â")
Text2.Text = Replace(Text1.Text, "b", "ß")
Text2.Text = Replace(Text1.Text, "c", "Ç")
Text2.Text = Replace(Text1.Text, "d", "ÃÂÂ")
Text2.Text = Replace(Text1.Text, "e", "ë")
Text2.Text = Replace(Text1.Text, "f", "F")
Text2.Text = Replace(Text1.Text, "g", "G")
Text2.Text = Replace(Text1.Text, "h", "H")
Text2.Text = Replace(Text1.Text, "i", "ÃÂÂ")
Text2.Text = Replace(Text1.Text, "j", "J")
Text2.Text = Replace(Text1.Text, "k", "K")
Text2.Text = Replace(Text1.Text, "l", "£")
Text2.Text = Replace(Text1.Text, "m", "M")
Text2.Text = Replace(Text1.Text, "n", "Ñ")
Text2.Text = Replace(Text1.Text, "o", "0")
Text2.Text = Replace(Text1.Text, "p", "þ")
Text2.Text = Replace(Text1.Text, "q", "Q")
Text2.Text = Replace(Text1.Text, "r", "R")
Text2.Text = Replace(Text1.Text, "s", "§")
Text2.Text = Replace(Text1.Text, "t", "T")
Text2.Text = Replace(Text1.Text, "u", "ú")
Text2.Text = Replace(Text1.Text, "v", "V")
Text2.Text = Replace(Text1.Text, "w", "W")
Text2.Text = Replace(Text1.Text, "x", "Ãâ€â€")
Text2.Text = Replace(Text1.Text, "y", "ÃÂÂ")
Text2.Text = Replace(Text1.Text, "z", "Z")
End Sub
then on a command button
- Code: Select all
call script
so what ever you type on text1 will be change on text two

and u need to change to what u want to change the letter too for example Text2.Text = Replace(Text1.Text, "a", "â") you can change it, lets say you want a to be z then u do it like this Text2.Text = Replace(Text1.Text, "a", "z") thats it, I think there othe ways but thats the way i done it
