Keyboard changes language

[SiddersAtHome]

Can anyone tell me why my keyboard will suddenly go "US" on me when I am editing VB code? I have not been able to track down when the switch happens but it may be after I actually run some code - none of which has been designed to change the keyboard setting by the way.

In essence, I suddenly find that the double quote marks above the number 2 suddenly becomes the @ key and the @ (above the single quote mark on my keyboard) becaomes the double quote.

Just so that you know this is only happening in Excel (both in the VB editor and in workbooks), I am having this problem at the moment in Excel, but have been using the "UK" keyboard without problems while typing this topic.

Any ideas/solutions greatly appreciated as it is driving me mad!

Many thanks

Sidders

 

[pgc01]

Hi Sidders

Can it be that you have installed a second keyboard in windows?

If that's the case to loop through the installed keyboards you press simultaneously the ALT key on the left side of the keyboard and one of the shift keys:

(Left ALT)+SHIFT

Maybe when you are editing code sometimes you press this key combination?

 

[SiddersAtHome]

PGC - Thanks for the idea but this does not seem to be the case.

 

[ljubo_gr]

For me, problem is in Selection.PrintOut Preview:=True When i set this to False, everything is fine. Comma decimal separator is fine(is on numerical side of keyboard). Cheers from year 2016