{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Country","ComboBox"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Country","index":0,"n_rows":199,"n_cols":5,"rows_kept":199,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Searchable Combobox in Excel VBA"]
[]
[null,"SL No.","Country","Area (Km2)","Filtered Country"]
[null,1,"Afghanistan",652860,{"$f":"_xlfn._xlws.FILTER(C5:C199,ISNUMBER(SEARCH(ComboBox!B4,C5:C199)),\"Not Found\")","v":"Afghanistan"}]
[null,2,"Albania",27400,"Albania"]
[null,3,"Algeria",2381740,"Algeria"]
[null,4,"Andorra",470,"Andorra"]
[null,5,"Angola",1246700,"Angola"]
[null,6,"Antigua and Barbuda",440,"Antigua and Barbuda"]
[null,7,"Argentina",2736690,"Argentina"]
[null,8,"Armenia",28470,"Armenia"]
[null,9,"Australia",7682300,"Australia"]
[null,10,"Austria",82409,"Austria"]
[null,11,"Azerbaijan",82658,"Azerbaijan"]
[null,12,"Bahamas",10010,"Bahamas"]
[null,13,"Bahrain",760,"Bahrain"]
[null,14,"Bangladesh",130170,"Bangladesh"]
[null,15,"Barbados",430,"Barbados"]
[null,16,"Belarus",202910,"Belarus"]
[null,17,"Belgium",30280,"Belgium"]
[null,18,"Belize",22810,"Belize"]
[null,19,"Benin",112760,"Benin"]
[null,20,"Bhutan",38117,"Bhutan"]
[null,21,"Bolivia",1083300,"Bolivia"]
[null,22,"Bosnia and Herzegovina",51000,"Bosnia and Herzegovina"]
[null,23,"Botswana",566730,"Botswana"]
[null,24,"Brazil",8358140,"Brazil"]
[null,25,"Brunei",5270,"Brunei"]
[null,26,"Bulgaria",108560,"Bulgaria"]
[null,27,"Burkina Faso",273600,"Burkina Faso"]
[null,28,"Burundi",25680,"Burundi"]
[null,29,"Côte d'Ivoire",318000,"Côte d'Ivoire"]
[null,30,"Cabo Verde",4030,"Cabo Verde"]
[null,31,"Cambodia",176520,"Cambodia"]
[null,32,"Cameroon",472710,"Cameroon"]
[null,33,"Canada",9093510,"Canada"]
[null,34,"Central African Republic",622980,"Central African Republic"]
[null,35,"Chad",1259200,"Chad"]
[null,36,"Chile",743532,"Chile"]
[null,37,"China",9388211,"China"]
[null,38,"Colombia",1109500,"Colombia"]
[null,39,"Comoros",1861,"Comoros"]
[null,40,"Congo (Congo-Brazzaville)",341500,"Congo (Congo-Brazzaville)"]
[null,41,"Costa Rica",51060,"Costa Rica"]
[null,42,"Croatia",55960,"Croatia"]
[null,43,"Cuba",106440,"Cuba"]
[null,44,"Cyprus",9240,"Cyprus"]
[null,45,"Czechia (Czech Republic)",77240,"Czechia (Czech Republic)"]
[null,46,"Democratic Republic of the Congo",2267050,"Democratic Republic of the Congo"]
[null,47,"Denmark",42430,"Denmark"]
[null,48,"Djibouti",23180,"Djibouti"]
[null,49,"Dominica",750,"Dominica"]
[null,50,"Dominican Republic",48320,"Dominican Republic"]
[null,51,"Ecuador",248360,"Ecuador"]
[null,52,"Egypt",995450,"Egypt"]
[null,53,"El Salvador",20720,"El Salvador"]
[null,54,"Equatorial Guinea",28050,"Equatorial Guinea"]
[null,55,"Eritrea",101000,"Eritrea"]
[null,56,"Estonia",42390,"Estonia"]
[null,57,"Eswatini (fmr. \"Swaziland\")",17200,"Eswatini (fmr. \"Swaziland\")"]
[null,58,"Ethiopia",1000000,"Ethiopia"]
[null,59,"Fiji",18270,"Fiji"]
[null,60,"Finland",303890,"Finland"]
[null,61,"France",547557,"France"]
[null,62,"Gabon",257670,"Gabon"]
[null,63,"Gambia",10120,"Gambia"]
[null,64,"Georgia",69490,"Georgia"]
[null,65,"Germany",348560,"Germany"]
[null,66,"Ghana",227540,"Ghana"]
[null,67,"Greece",128900,"Greece"]
[null,68,"Grenada",340,"Grenada"]
[null,69,"Guatemala",107160,"Guatemala"]
[null,70,"Guinea",245720,"Guinea"]
[null,71,"Guinea-Bissau",28120,"Guinea-Bissau"]
[null,72,"Guyana",196850,"Guyana"]
[null,73,"Haiti",27560,"Haiti"]
[null,74,"Holy See",0,"Holy See"]
[null,75,"Honduras",111890,"Honduras"]
[null,76,"Hungary",90530,"Hungary"]
[null,77,"Iceland",100250,"Iceland"]
[null,78,"India",2973190,"India"]
[null,79,"Indonesia",1811570,"Indonesia"]
[null,80,"Iran",1628550,"Iran"]
[null,81,"Iraq",434320,"Iraq"]
[null,82,"Ireland",68890,"Ireland"]
[null,83,"Israel",21640,"Israel"]
[null,84,"Italy",294140,"Italy"]
[null,85,"Jamaica",10830,"Jamaica"]
[null,86,"Japan",364555,"Japan"]
[null,87,"Jordan",88780,"Jordan"]
[null,88,"Kazakhstan",2699700,"Kazakhstan"]
[null,89,"Kenya",569140,"Kenya"]
[null,90,"Kiribati",810,"Kiribati"]
[null,91,"Kuwait",17820,"Kuwait"]
[null,92,"Kyrgyzstan",191800,"Kyrgyzstan"]
[null,93,"Laos",230800,"Laos"]
[null,94,"Latvia",62200,"Latvia"]
[null,95,"Lebanon",10230,"Lebanon"]
[null,96,"Lesotho",30360,"Lesotho"]
[null,97,"Liberia",96320,"Liberia"]
[null,98,"Libya",1759540,"Libya"]
[null,99,"Liechtenstein",160,"Liechtenstein"]
[null,100,"Lithuania",62674,"Lithuania"]
[null,101,"Luxembourg",2590,"Luxembourg"]
[null,102,"Madagascar",581795,"Madagascar"]
[null,103,"Malawi",94280,"Malawi"]
[null,104,"Malaysia",328550,"Malaysia"]
[null,105,"Maldives",300,"Maldives"]
[null,106,"Mali",1220190,"Mali"]
[null,107,"Malta",320,"Malta"]
[null,108,"Marshall Islands",180,"Marshall Islands"]
[null,109,"Mauritania",1030700,"Mauritania"]
[null,110,"Mauritius",2030,"Mauritius"]
[null,111,"Mexico",1943950,"Mexico"]
[null,112,"Micronesia",700,"Micronesia"]
[null,113,"Moldova",32850,"Moldova"]
[null,114,"Monaco",1,"Monaco"]
[null,115,"Mongolia",1553560,"Mongolia"]
[null,116,"Montenegro",13450,"Montenegro"]
[null,117,"Morocco",446300,"Morocco"]
[null,118,"Mozambique",786380,"Mozambique"]
[null,119,"Myanmar (formerly Burma)",653290,"Myanmar (formerly Burma)"]
[null,120,"Namibia",823290,"Namibia"]
[null,121,"Nauru",20,"Nauru"]
[null,122,"Nepal",143350,"Nepal"]
[null,123,"Netherlands",33720,"Netherlands"]
[null,124,"New Zealand",263310,"New Zealand"]
[null,125,"Nicaragua",120340,"Nicaragua"]
[null,126,"Niger",1266700,"Niger"]
[null,127,"Nigeria",910770,"Nigeria"]
[null,128,"North Korea",120410,"North Korea"]
[null,129,"North Macedonia",25220,"North Macedonia"]
[null,130,"Norway",365268,"Norway"]
[null,131,"Oman",309500,"Oman"]
[null,132,"Pakistan",770880,"Pakistan"]
[null,133,"Palau",460,"Palau"]
[null,134,"Palestine State",6020,"Palestine State"]
[null,135,"Panama",74340,"Panama"]
[null,136,"Papua New Guinea",452860,"Papua New Guinea"]
[null,137,"Paraguay",397300,"Paraguay"]
[null,138,"Peru",1280000,"Peru"]
[null,139,"Philippines",298170,"Philippines"]
[null,140,"Poland",306230,"Poland"]
[null,141,"Portugal",91590,"Portugal"]
[null,142,"Qatar",11610,"Qatar"]
[null,143,"Romania",230170,"Romania"]
[null,144,"Russia",16376870,"Russia"]
[null,145,"Rwanda",24670,"Rwanda"]
[null,146,"Saint Kitts and Nevis",260,"Saint Kitts and Nevis"]
[null,147,"Saint Lucia",610,"Saint Lucia"]
[null,148,"Saint Vincent and the Grenadines",390,"Saint Vincent and the Grenadines"]
[null,149,"Samoa",2830,"Samoa"]
[null,150,"San Marino",60,"San Marino"]
[null,151,"Sao Tome and Principe",960,"Sao Tome and Principe"]
[null,152,"Saudi Arabia",2149690,"Saudi Arabia"]
[null,153,"Senegal",192530,"Senegal"]
[null,154,"Serbia",87460,"Serbia"]
[null,155,"Seychelles",460,"Seychelles"]
[null,156,"Sierra Leone",72180,"Sierra Leone"]
[null,157,"Singapore",700,"Singapore"]
[null,158,"Slovakia",48088,"Slovakia"]
[null,159,"Slovenia",20140,"Slovenia"]
[null,160,"Solomon Islands",27990,"Solomon Islands"]
[null,161,"Somalia",627340,"Somalia"]
[null,162,"South Africa",1213090,"South Africa"]
[null,163,"South Korea",97230,"South Korea"]
[null,164,"South Sudan",610952,"South Sudan"]
[null,165,"Spain",498800,"Spain"]
[null,166,"Sri Lanka",62710,"Sri Lanka"]
[null,167,"Sudan",1765048,"Sudan"]
[null,168,"Suriname",156000,"Suriname"]
[null,169,"Sweden",410340,"Sweden"]
[null,170,"Switzerland",39516,"Switzerland"]
[null,171,"Syria",183630,"Syria"]
[null,172,"Tajikistan",139960,"Tajikistan"]
[null,173,"Tanzania",885800,"Tanzania"]
[null,174,"Thailand",510890,"Thailand"]
[null,175,"Timor-Leste",14870,"Timor-Leste"]
[null,176,"Togo",54390,"Togo"]
[null,177,"Tonga",720,"Tonga"]
[null,178,"Trinidad and Tobago",5130,"Trinidad and Tobago"]
[null,179,"Tunisia",155360,"Tunisia"]
[null,180,"Turkey",769630,"Turkey"]
[null,181,"Turkmenistan",469930,"Turkmenistan"]
[null,182,"Tuvalu",30,"Tuvalu"]
[null,183,"Uganda",199810,"Uganda"]
[null,184,"Ukraine",579320,"Ukraine"]
[null,185,"United Arab Emirates",83600,"United Arab Emirates"]
[null,186,"United Kingdom",241930,"United Kingdom"]
[null,187,"United States of America",9147420,"United States of America"]
[null,188,"Uruguay",175020,"Uruguay"]
[null,189,"Uzbekistan",425400,"Uzbekistan"]
[null,190,"Vanuatu",12190,"Vanuatu"]
[null,191,"Venezuela",882050,"Venezuela"]
[null,192,"Vietnam",310070,"Vietnam"]
[null,193,"Yemen",527970,"Yemen"]
[null,194,"Zambia",743390,"Zambia"]
[null,195,"Zimbabwe",386850,"Zimbabwe"]

{"sheet":"ComboBox","index":1,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Searchable Combobox in Excel VBA"]
[]
[null,""]