Change keyboard Regional setting

[Deer Hunter]

Hi,

I have some problems with the keyboard input.
Some users of my excel sheet use the Dutch Regional keyboard setting, but
they must use the English (United States) Regional setting.
Can I implement this in the VBA code, so that the user don't have to set
this manually?

Any help is welcome!

Regards,

Mike

 

[keepitcool]

Hi.

Why do you need to change Reg Settings?

I'm Dutch.. and I have several apps in both English and Dutch
(and Finnish for that matter..)

As a user .. I'd be very displeased with any application that would change
my regional settings. Some people (me included) have it all setup to the
way they like/neeed/expect. I would expect ANY application to leave them
alone.


See Application.International in Excel VBA on how to READ them.

Note that if Application.UseSystemSeparators = False
then you'll ALSO have to look at Application.DecimalSeparator &
ThousandsSeparator.

So the question remains:

Which settings are exactly your problem (and are they a problem on
inserting formulas) or to achieve universal display?

Please also mention any Excel and or OS verions.


keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >

 

[jaf]

Hi Mike,
Perhaps you can use the Office Visual Keyboard to support multiple
languages.

Off. 2000 http://office.microsoft.com/downloads/2000/viskeyboard.aspx
Off. 2002 http://office.microsoft.com/downloads/2002/vkeyinst.aspx