Reference for German Code

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

robkiolbasa - 19 Sep 2007 14:38 GMT

Hello,

I have a user who is opening an excel sheet with some German
referenced and is getting an error message because it is referencing a
German keystroke. The problem code is below:

Application.OnKey "{ENDE}", "aendern"
Application.OnKey "{einfg}", "einfueg"
Application.OnKey "^{ENDE}", "aendern_voll"

Basically, his US setup does not recognize the keystrokes ENDE and
einfg (end and insert). I can change them to english and it works,
but I do not want to do this because this is a shared spreadsheet.

Is there a change I can make on his client that will enable this
coding?

Reply to this Message

Jim Rech - 19 Sep 2007 14:52 GMT

Perhaps you can use:

Application.International(xlCountrySetting)

to run country specific code (US settings return 1).

Signature

Jim

| Hello,
|
[quoted text clipped - 12 lines]
| Is there a change I can make on his client that will enable this
| coding?

Reply to this Message