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


"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

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

Off. 2000 http://office.microsoft.com/download...skeyboard.aspx
Off. 2002 http://office.microsoft.com/download.../vkeyinst.aspx

--

John

johnf202 at hotmail dot com


"Deer Hunter" wrote in message
...
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