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


"Deer Hunter" wrote:

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