Get current keyboard layout with VBA

[MeiR_ct]

Hi all.

How can I get the current keyboard layout?

I'm asking this because when "Application.OnKey" tries to assign a key combination, which contains a character in other layout then the active, it will result run-time error 1004 with the following message:

Method 'OnKey' of object '_Application' failed

So I want to check the layout first, before running "Application.OnKey".
And I wonder, can Excel listen and know when the keyboard layout gets changed?

Thanks in advance, Meir.

 

[MeiR_ct]

Oops, a typo.
I meant: other layout than the active*

Does anyone have a clue how to help me?