Keyboard Mapping changed while working in VBA

Larry Haydn

Board Regular
Joined
Jul 18, 2019
Messages
92
Office Version
  1. 365
Platform
  1. Windows
Here is a strange thing:

I was working on an Excel VBA project.
The original file was done by Japanese and so the locale would be Japan.

Since I am not using Japanese but English, I use US English.

Occasionally, the keyboard mapping will automatically change, as follows:
" becomes @
\ becomes the British Pound sign

...and a few other funky stuff.

Question:
Why does this happen?
How can I prevent this?
How can I switch back to US English keyboard mapping other that restarting my PC?

I am using Windows 10, Office 365.
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

GWteB

Well-known Member
Joined
Sep 10, 2010
Messages
1,295
Office Version
  1. 2013
Platform
  1. Windows
Not sure how to prevent this but switching back can be done by pressing (and holding down) the Windows key (with windows logo). Now toggle with the space bar to choose desired language / keyboard combination.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,809
Messages
5,574,435
Members
412,592
Latest member
moonsugar
Top