swithc IME input method automatically when Textbox gets focus

JKR · 05-13-2008, 04:13 AM

Dear all,

I've done a VBA for Excel UserForm containing some text boxes to enter text. This text is to be entered in european languages for some text boxes, in Chinese characters for others and in Pinyin with tone marks for still some others.
This works fine so far.
My question is: It is very annoying to manually switch the input method using the language bar each time that I have to go to another text box. I'd rather have some VBA code allowing to swith to the correct input method as soon as the text box gets the focus by clicking into it. Got the idea?

Any hints how to do this?

wǒ xiàng yào zì dòng de bànfǎ

我想要自动的办法

J'aimerais disposer d'une méthode automatique.

Es wäre schön, wenn das automatisch ginge.

JKR · 05-19-2008, 12:00 AM

I finally found out how to do it myself, so the issue can be closed.

And here is the solution:
it can't be done in VBA, but you can use the windows API to do it using ActivateKeyboardLayout.

I found the information I needed here:
http://binaryworld.net/Main/CodeDetail.aspx?CodeId=3694

05-13-2008, 04:13 AM	#1 (permalink)
JKR Registered User Join Date: Jan 2007 Location: Beijing Posts: 31 OS: XP	swithc IME input method automatically when Textbox gets focus Dear all, I've done a VBA for Excel UserForm containing some text boxes to enter text. This text is to be entered in european languages for some text boxes, in Chinese characters for others and in Pinyin with tone marks for still some others. This works fine so far. My question is: It is very annoying to manually switch the input method using the language bar each time that I have to go to another text box. I'd rather have some VBA code allowing to swith to the correct input method as soon as the text box gets the focus by clicking into it. Got the idea? Any hints how to do this? wǒ xiàng yào zì dòng de bànfǎ 我想要自动的办法 J'aimerais disposer d'une méthode automatique. Es wäre schön, wenn das automatisch ginge.

05-19-2008, 12:00 AM	#2 (permalink)
JKR Registered User Join Date: Jan 2007 Location: Beijing Posts: 31 OS: XP	Re: swithc IME input method automatically when Textbox gets focus I finally found out how to do it myself, so the issue can be closed. And here is the solution: it can't be done in VBA, but you can use the windows API to do it using ActivateKeyboardLayout. I found the information I needed here: http://binaryworld.net/Main/CodeDetail.aspx?CodeId=3694