Skip to main content

xlCountrySetting

You can use this to get the language chosen in Windows Regional Settings :

Application.International(xlCountrySetting)

This will give you the Country / Region code, for example 86 for China and 1 for United States.

Complete list of International(xlCountrySetting) in Windows
COUNTRY COUNTRY / REGION CODE ISO CODES
Afghanistan 93 AF / AFG
Albania 355 AL / ALB
Algeria 213 DZ / DZA
American Samoa 1-684 AS / ASM
Andorra 376 AD / AND
Angola 244 AO / AGO
Anguilla 1-264 AI / AIA
Antarctica 672 AQ / ATA
Antigua and Barbuda 1-268 AG / ATG
Argentina 54 AR / ARG
Armenia 374 AM / ARM
Aruba 297 AW / ABW
Australia 61 AU / AUS
Austria 43 AT / AUT
Azerbaijan 994 AZ / AZE
Bahamas 1-242 BS / BHS
Bahrain 973 BH / BHR
Bangladesh 880 BD / BGD
Barbados 1-246 BB / BRB
Belarus 375 BY / BLR
Belgium 32 BE / BEL
Belize 501 BZ / BLZ
Benin 229 BJ / BEN
Bermuda 1-441 BM / BMU
Bhutan 975 BT / BTN
Bolivia 591 BO / BOL
Bosnia and Herzegovina 387 BA / BIH
Botswana 267 BW / BWA
Brazil 55 BR / BRA
British Indian Ocean Territory 246 IO / IOT
British Virgin Islands 1-284 VG / VGB
Brunei 673 BN / BRN
Bulgaria 359 BG / BGR
Burkina Faso 226 BF / BFA
Burundi 257 BI / BDI
Cambodia 855 KH / KHM
Cameroon 237 CM / CMR
Canada 1 CA / CAN
Cape Verde 238 CV / CPV
Cayman Islands 1-345 KY / CYM
Central African Republic 236 CF / CAF
Chad 235 TD / TCD
Chile 56 CL / CHL
China 86 CN / CHN
Christmas Island 61 CX / CXR
Cocos Islands 61 CC / CCK
Colombia 57 CO / COL
Comoros 269 KM / COM
Cook Islands 682 CK / COK
Costa Rica 506 CR / CRI
Croatia 385 HR / HRV
Cuba 53 CU / CUB
Curacao 599 CW / CUW
Cyprus 357 CY / CYP
Czech Republic 420 CZ / CZE
Democratic Republic of the Congo 243 CD / COD
Denmark 45 DK / DNK
Djibouti 253 DJ / DJI
Dominica 1-767 DM / DMA
Dominican Republic 1-809, 1-829, 1-849 DO / DOM
East Timor 670 TL / TLS
Ecuador 593 EC / ECU
Egypt 20 EG / EGY
El Salvador 503 SV / SLV
Equatorial Guinea 240 GQ / GNQ
Eritrea 291 ER / ERI
Estonia 372 EE / EST
Ethiopia 251 ET / ETH
Falkland Islands 500 FK / FLK
Faroe Islands 298 FO / FRO
Fiji 679 FJ / FJI
Finland 358 FI / FIN
France 33 FR / FRA
French Polynesia 689 PF / PYF
Gabon 241 GA / GAB
Gambia 220 GM / GMB
Georgia 995 GE / GEO
Germany 49 DE / DEU
Ghana 233 GH / GHA
Gibraltar 350 GI / GIB
Greece 30 GR / GRC
Greenland 299 GL / GRL
Grenada 1-473 GD / GRD
Guam 1-671 GU / GUM
Guatemala 502 GT / GTM
Guernsey 44-1481 GG / GGY
Guinea 224 GN / GIN
Guinea-Bissau 245 GW / GNB
Guyana 592 GY / GUY
Haiti 509 HT / HTI
Honduras 504 HN / HND
Hong Kong 852 HK / HKG
Hungary 36 HU / HUN
Iceland 354 IS / ISL
India 91 IN / IND
Indonesia 62 ID / IDN
Iran 98 IR / IRN
Iraq 964 IQ / IRQ
Ireland 353 IE / IRL
Isle of Man 44-1624 IM / IMN
Israel 972 IL / ISR
Italy 39 IT / ITA
Ivory Coast 225 CI / CIV
Jamaica 1-876 JM / JAM
Japan 81 JP / JPN
Jersey 44-1534 JE / JEY
Jordan 962 JO / JOR
Kazakhstan 7 KZ / KAZ
Kenya 254 KE / KEN
Kiribati 686 KI / KIR
Kosovo 383 XK / XKX
Kuwait 965 KW / KWT
Kyrgyzstan 996 KG / KGZ
Laos 856 LA / LAO
Latvia 371 LV / LVA
Lebanon 961 LB / LBN
Lesotho 266 LS / LSO
Liberia 231 LR / LBR
Libya 218 LY / LBY
Liechtenstein 423 LI / LIE
Lithuania 370 LT / LTU
Luxembourg 352 LU / LUX
Macau 853 MO / MAC
Macedonia 389 MK / MKD
Madagascar 261 MG / MDG
Malawi 265 MW / MWI
Malaysia 60 MY / MYS
Maldives 960 MV / MDV
Mali 223 ML / MLI
Malta 356 MT / MLT
Marshall Islands 692 MH / MHL
Mauritania 222 MR / MRT
Mauritius 230 MU / MUS
Mayotte 262 YT / MYT
Mexico 52 MX / MEX
Micronesia 691 FM / FSM
Moldova 373 MD / MDA
Monaco 377 MC / MCO
Mongolia 976 MN / MNG
Montenegro 382 ME / MNE
Montserrat 1-664 MS / MSR
Morocco 212 MA / MAR
Mozambique 258 MZ / MOZ
Myanmar 95 MM / MMR
Namibia 264 NA / NAM
Nauru 674 NR / NRU
Nepal 977 NP / NPL
Netherlands 31 NL / NLD
Netherlands Antilles 599 AN / ANT
New Caledonia 687 NC / NCL
New Zealand 64 NZ / NZL
Nicaragua 505 NI / NIC
Niger 227 NE / NER
Nigeria 234 NG / NGA
Niue 683 NU / NIU
North Korea 850 KP / PRK
Northern Mariana Islands 1-670 MP / MNP
Norway 47 NO / NOR
Oman 968 OM / OMN
Pakistan 92 PK / PAK
Palau 680 PW / PLW
Palestine 970 PS / PSE
Panama 507 PA / PAN
Papua New Guinea 675 PG / PNG
Paraguay 595 PY / PRY
Peru 51 PE / PER
Philippines 63 PH / PHL
Pitcairn 64 PN / PCN
Poland 48 PL / POL
Portugal 351 PT / PRT
Puerto Rico 1-787, 1-939 PR / PRI
Qatar 974 QA / QAT
Republic of the Congo 242 CG / COG
Reunion 262 RE / REU
Romania 40 RO / ROU
Russia 7 RU / RUS
Rwanda 250 RW / RWA
Saint Barthelemy 590 BL / BLM
Saint Helena 290 SH / SHN
Saint Kitts and Nevis 1-869 KN / KNA
Saint Lucia 1-758 LC / LCA
Saint Martin 590 MF / MAF
Saint Pierre and Miquelon 508 PM / SPM
Saint Vincent and the Grenadines 1-784 VC / VCT
Samoa 685 WS / WSM
San Marino 378 SM / SMR
Sao Tome and Principe 239 ST / STP
Saudi Arabia 966 SA / SAU
Senegal 221 SN / SEN
Serbia 381 RS / SRB
Seychelles 248 SC / SYC
Sierra Leone 232 SL / SLE
Singapore 65 SG / SGP
Sint Maarten 1-721 SX / SXM
Slovakia 421 SK / SVK
Slovenia 386 SI / SVN
Solomon Islands 677 SB / SLB
Somalia 252 SO / SOM
South Africa 27 ZA / ZAF
South Korea 82 KR / KOR
South Sudan 211 SS / SSD
Spain 34 ES / ESP
Sri Lanka 94 LK / LKA
Sudan 249 SD / SDN
Suriname 597 SR / SUR
Svalbard and Jan Mayen 47 SJ / SJM
Swaziland 268 SZ / SWZ
Sweden 46 SE / SWE
Switzerland 41 CH / CHE
Syria 963 SY / SYR
Taiwan 886 TW / TWN
Tajikistan 992 TJ / TJK
Tanzania 255 TZ / TZA
Thailand 66 TH / THA
Togo 228 TG / TGO
Tokelau 690 TK / TKL
Tonga 676 TO / TON
Trinidad and Tobago 1-868 TT / TTO
Tunisia 216 TN / TUN
Turkey 90 TR / TUR
Turkmenistan 993 TM / TKM
Turks and Caicos Islands 1-649 TC / TCA
Tuvalu 688 TV / TUV
U.S. Virgin Islands 1-340 VI / VIR
Uganda 256 UG / UGA
Ukraine 380 UA / UKR
United Arab Emirates 971 AE / ARE
United Kingdom 44 GB / GBR
United States 1 US / USA
Uruguay 598 UY / URY
Uzbekistan 998 UZ / UZB
Vanuatu 678 VU / VUT
Vatican 379 VA / VAT
Venezuela 58 VE / VEN
Vietnam 84 VN / VNM
Wallis and Futuna 681 WF / WLF
Western Sahara 212 EH / ESH
Yemen 967 YE / YEM
Zambia 260 ZM / ZMB
Zimbabwe 263 ZW / ZWE

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>