Change keyboard Regional setting

  • Thread starter Thread starter Deer Hunter
  • Start date Start date
D

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
 
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 >
 
Back
Top