how to change language by VBA code

[jamaarneen]

Hi

My form have several textboxes, which some of them should be in one language, tha others in another language
The goal here is: when the user clicks in the textbox, it should automatically change to the desired language.

How do I achieve this?

(my office currently have 4 languages, working perfect)

Thanks for your help

 

[jsteph]

If it's for freeform text or dynamic text data, then Google should have a Translate API.

If it's standard labels, help topics, etc, then typically this is table-driven.
--Jim

 

[jamaarneen]

Thanks Jim

But the thing is not about 'translating'.
I am using LeftToRight languages, and also RightToLeft. they are but installed and working on my computer.

Normally when I want to switch from LTR to RTL, I'll do it manually by clicking Alt+Shift. but her I would like that it should change automatically. for example: Tha name is in RTL language, while the address is in LTR. I want that by clicking on the textbox to fill in data, the keyboard language should automatically be how it should.

Maybe I should call it: how to change [red]keyboard[/red]language in VBA code

Thanks

 

[MakeItSo]

Maybe I should call it: how to change keyboardlanguage in VBA code

Yepp, good idea. I googled it and found what you need.
Check out the final response in this thread:
Thread on MSDN

;-)

[navy]"We had to turn off that service to comply with the CDA Bill."[/navy]
- The Bastard Operator From Hell