Compile error: Procedure too large Microsoft VBA (private sub change)

Paeng23

New Member
Joined
Aug 22, 2024
Messages
2
Office Version
  1. 365
  2. 2016
  3. 2010
Platform
  1. Windows
Please help how to shorten :cry::cry:

VBA Code:
Private Sub cmbProvince_Change()
cmbCity.Clear
cmbboxselect = cmbProvince.Value
Select Case cmbboxselect
    Case "BASILAN"
        cmbCity.AddItem "AL-BARKA"
        cmbCity.AddItem "LAMITAN"
        cmbCity.AddItem "LANTAWAN"
        cmbCity.AddItem "MALUSO"
        cmbCity.AddItem "SUMISIP"
        cmbCity.AddItem "TIPO-TIPO"
        cmbCity.AddItem "TUBURAN"
    Case "LANAO DEL SUR"
        cmbCity.AddItem "BACOLOD GRANDE"
        cmbCity.AddItem "BALABAGAN"
        cmbCity.AddItem "BALINDONG"
        cmbCity.AddItem "BAYANG"
        cmbCity.AddItem "BINIDAYAN"
        cmbCity.AddItem "BUADIPOSO BUNTONG"
        cmbCity.AddItem "BUBONG"
        cmbCity.AddItem "BUMARAN"
        cmbCity.AddItem "BUTIG"
        cmbCity.AddItem "CALANOGAS"
        cmbCity.AddItem "GANASSI"
        cmbCity.AddItem "KAPAI"
        cmbCity.AddItem "KAPATAGAN"
        cmbCity.AddItem "LUMBA BAYABAO"
        cmbCity.AddItem "LUMBATAN"
        cmbCity.AddItem "LUMBAYANAGUE"
        cmbCity.AddItem "MACADOR ANDONG"
        cmbCity.AddItem "MADALUM"
        cmbCity.AddItem "MADAMBA"
        cmbCity.AddItem "MAGUING"
        cmbCity.AddItem "MALABANG"
        cmbCity.AddItem "MARAGONG"
        cmbCity.AddItem "MARANTAO"
        cmbCity.AddItem "MARAWI CITY"
        cmbCity.AddItem "MASUI"
        cmbCity.AddItem "MULONDO"
        cmbCity.AddItem "PAGAYAWAN"
        cmbCity.AddItem "PIAGAPO"
        cmbCity.AddItem "POONA BAYABAO"
        cmbCity.AddItem "PUALAS"
        cmbCity.AddItem "RAMAIN-DITSAAN"
        cmbCity.AddItem "SAGUIARAN"
        cmbCity.AddItem "SULTAN DUMALONDONG"
        cmbCity.AddItem "SULTAN GUMANDER"
        cmbCity.AddItem "TAGOLOAN-II"
        cmbCity.AddItem "TAMPARAN"
        cmbCity.AddItem "TARAKA"
        cmbCity.AddItem "TUBARAN"
        cmbCity.AddItem "TUGAYA"
        cmbCity.AddItem "WAO"
    Case "MAGUINDANAO"
        cmbCity.AddItem "AMPATUAN"
        cmbCity.AddItem "BARIRA"
        cmbCity.AddItem "BULDON"
        cmbCity.AddItem "BULUAN"
        cmbCity.AddItem "COTABATO CITY"
        cmbCity.AddItem "DATU ABDULLAH SANGKI"
        cmbCity.AddItem "DATU ANGGAL MIDTIMBANG"
        cmbCity.AddItem "DATU BLAH T. SINSUAT"
        cmbCity.AddItem "DATU HOFFER AMPATUAN"
        cmbCity.AddItem "DATU MONTAWAL"
        cmbCity.AddItem "DATU ODIN SINSUAT (DINAIG)"
        cmbCity.AddItem "DATU SALIBO"
        cmbCity.AddItem "DATU SAUDI-AMPATUAN"
        cmbCity.AddItem "DATU UNSAY"
        cmbCity.AddItem "DATU PAGLAS"
        cmbCity.AddItem "DATU PIANG"
        cmbCity.AddItem "GEN. S.K. PENDATUN"
        cmbCity.AddItem "GUINDULUNGAN"
        cmbCity.AddItem "KABUNTALAN"
        cmbCity.AddItem "MAMASAPANO"
        cmbCity.AddItem "MANGUDADATU"
        cmbCity.AddItem "MAGANOY"
        cmbCity.AddItem "MATANOG"
        cmbCity.AddItem "NORTHERN KABUNTALAN"
        cmbCity.AddItem "PAGLAT"
        cmbCity.AddItem "PANDAG"
        cmbCity.AddItem "PAGALUNGAN"
        cmbCity.AddItem "PARANG"
        cmbCity.AddItem "RAJAH BUAYAN"
        cmbCity.AddItem "SHARIFF AGUAK"
        cmbCity.AddItem "SHARIFF SAYDONA MUSTAPHA"
        cmbCity.AddItem "SULTAN MASTURA"
        cmbCity.AddItem "SULTAN SA BARONGIS"
        cmbCity.AddItem "SOUTH UPI"
        cmbCity.AddItem "SULTAN KUDARAT"
        cmbCity.AddItem "TALITAY"
        cmbCity.AddItem "TALAYAN"
        cmbCity.AddItem "UPI"
    Case "SULU"
        cmbCity.AddItem "INDANAN"
        cmbCity.AddItem "JOLO"
        cmbCity.AddItem "KALINGALAN KALAUANG"
        cmbCity.AddItem "LUGUS"
        cmbCity.AddItem "LUUK"
        cmbCity.AddItem "MAIMBUNG"
        cmbCity.AddItem "MARUNGAS"
        cmbCity.AddItem "PANAMAO"
        cmbCity.AddItem "PANDAMI"
        cmbCity.AddItem "PANGLIMA ESTINO"
        cmbCity.AddItem "PANGUNTARAN"
        cmbCity.AddItem "PARANG"
        cmbCity.AddItem "PATA"
        cmbCity.AddItem "PATIKUL"
        cmbCity.AddItem "SIASI"
        cmbCity.AddItem "TALIPAO"
        cmbCity.AddItem "TAPUL"
        cmbCity.AddItem "TONGKIL"
    Case "TAWI-TAWI"
        cmbCity.AddItem "BONGAO"
        cmbCity.AddItem "CAGAYAN DE SULU (MAPUN)"
        cmbCity.AddItem "LANGUYAN"
        cmbCity.AddItem "PANGLIMA SUGALA (BALIMBING)"
        cmbCity.AddItem "SAPA-SAPA"
        cmbCity.AddItem "SIBUTU"
        cmbCity.AddItem "SIMUNOL"
        cmbCity.AddItem "SITANGKAI"
        cmbCity.AddItem "SOUTH UBIAN"
        cmbCity.AddItem "TAGANAK (TURTLE ISLAND)"
        cmbCity.AddItem "TANDU BAS"
    Case "ALBAY"
        cmbCity.AddItem "BACACAY"
        cmbCity.AddItem "CAMALIG"
        cmbCity.AddItem "DARAGA(LOCSIN)"
        cmbCity.AddItem "GUINOBATAN"
        cmbCity.AddItem "JOVELLAR"
        cmbCity.AddItem "LEGAZPI CITY"
        cmbCity.AddItem "LIBON"
        cmbCity.AddItem "LIGAO CITY"
        cmbCity.AddItem "MALILIPOT"
        cmbCity.AddItem "MALINAO"
        cmbCity.AddItem "MANITO"
        cmbCity.AddItem "OAS"
        cmbCity.AddItem "PIO DURAN(MALACBALAC)"
        cmbCity.AddItem "POLANGUI"
        cmbCity.AddItem "RAPU-RAPU"
        cmbCity.AddItem "SANTO DOMINGO"
        cmbCity.AddItem "TABACO CITY"
        cmbCity.AddItem "TIWI"
    Case "CAMARINES NORTE"
        cmbCity.AddItem "BASUD"
        cmbCity.AddItem "CAPALONGA"
        cmbCity.AddItem "DAET"
        cmbCity.AddItem "JOSE PANGANIBAN"
        cmbCity.AddItem "LABO"
        cmbCity.AddItem "MERCEDES"
        cmbCity.AddItem "PARACALE"
        cmbCity.AddItem "SAN LORENZO RUIZ(FORMELY IMELDA)"
        cmbCity.AddItem "SAN VICENTE"
        cmbCity.AddItem "SANTA ELENA"
        cmbCity.AddItem "TALISAY"
        cmbCity.AddItem "TULA-NA-LUPA"
        cmbCity.AddItem "VINZONS"
    Case "CAMARINES SUR"
        cmbCity.AddItem "BAAO"
        cmbCity.AddItem "BALATAN"
        cmbCity.AddItem "BATO"
        cmbCity.AddItem "BOMBON"
        cmbCity.AddItem "BUHI"
        cmbCity.AddItem "BULA"
        cmbCity.AddItem "CABUSAO"
        cmbCity.AddItem "CALABANGA"
        cmbCity.AddItem "CAMALIGAN"
        cmbCity.AddItem "CANAMAN"
        cmbCity.AddItem "CARAMOAN"
        cmbCity.AddItem "DEL GALLEGO"
        cmbCity.AddItem "GAINZA"
        cmbCity.AddItem "GARCHITORENA"
        cmbCity.AddItem "GOA"
        cmbCity.AddItem "IRIGA CITY"
        cmbCity.AddItem "LAGUNOY"
        cmbCity.AddItem "LIBMANAN"
        cmbCity.AddItem "LUPI"
        cmbCity.AddItem "MAGARAO"
        cmbCity.AddItem "MILAOR"
        cmbCity.AddItem "MINALABAC"
        cmbCity.AddItem "NABUA"
        cmbCity.AddItem "NAGA CITY"
        cmbCity.AddItem "OCAMPO"
        cmbCity.AddItem "PAMPLONA"
        cmbCity.AddItem "PASACAO"
        cmbCity.AddItem "PILI"
        cmbCity.AddItem "PRESENTACION"
        cmbCity.AddItem "RAGAY"
        cmbCity.AddItem "SAGNAY"
        cmbCity.AddItem "SAN FERNANDO"
        cmbCity.AddItem "SAN JOSE"
        cmbCity.AddItem "SIPOCOT"
        cmbCity.AddItem "SIRUMA"
        cmbCity.AddItem "TIGAON"
        cmbCity.AddItem "TINAMBAC"
    Case "CATANDUANES"
        cmbCity.AddItem "BAGAMANOC"
        cmbCity.AddItem "BARAS"
        cmbCity.AddItem "BATO"
        cmbCity.AddItem "CARAMORAN"
        cmbCity.AddItem "GIGMOTO"
        cmbCity.AddItem "PANDAN"
        cmbCity.AddItem "PANGANIBAN"
        cmbCity.AddItem "SAN ANDRES"
        cmbCity.AddItem "SAN MIGUEL"
        cmbCity.AddItem "VIGA"
        cmbCity.AddItem "VIRAC"
    Case "MASBATE"
        cmbCity.AddItem "AROROY"
        cmbCity.AddItem "BALENO"
        cmbCity.AddItem "BALUD"
        cmbCity.AddItem "BATUAN"
        cmbCity.AddItem "BUENAVISTA"
        cmbCity.AddItem "CATAINGAN"
        cmbCity.AddItem "CAWAYAN"
        cmbCity.AddItem "CLAVERIA"
        cmbCity.AddItem "DIMASALANG"
        cmbCity.AddItem "ESPERANZA"
        cmbCity.AddItem "MANDAON"
        cmbCity.AddItem "MASBATE"
        cmbCity.AddItem "MILAGROS"
        cmbCity.AddItem "MOBO"
        cmbCity.AddItem "MONREAL"
        cmbCity.AddItem "PALANAS"
        cmbCity.AddItem "PIO V. CORPUZ"
        cmbCity.AddItem "PLACER"
        cmbCity.AddItem "SAN FERNANDO"
        cmbCity.AddItem "SAN JACINTO"
        cmbCity.AddItem "SAN PASCUAL"
        cmbCity.AddItem "USON"
    Case "SORSOGON"
        cmbCity.AddItem "BACON"
        cmbCity.AddItem "BARCELONA"
        cmbCity.AddItem "BULAN"
        cmbCity.AddItem "BULUSAN"
        cmbCity.AddItem "CASIGURAN"
        cmbCity.AddItem "CASTILLA"
        cmbCity.AddItem "DONSOL"
        cmbCity.AddItem "GUBAT"
        cmbCity.AddItem "IROSIN"
        cmbCity.AddItem "JUBAN"
        cmbCity.AddItem "MAGALLANES"
        cmbCity.AddItem "MATNOG"
        cmbCity.AddItem "PILAR"
        cmbCity.AddItem "PRIETO DIAZ"
        cmbCity.AddItem "SANTA MAGDALENA"
        cmbCity.AddItem "SORSOGON"
    Case "NORTH COTABATO"
        cmbCity.AddItem "ALAMADA"
        cmbCity.AddItem "ALEOSAN"
        cmbCity.AddItem "ANTIPAS"
        cmbCity.AddItem "ARAKAN"
        cmbCity.AddItem "BANISILAN"
        cmbCity.AddItem "CARMEN"
        cmbCity.AddItem "KABACAN"
        cmbCity.AddItem "KIDAPAWAN CITY"
        cmbCity.AddItem "LIBUNGAN"
        cmbCity.AddItem "MLANG"
        cmbCity.AddItem "MAGPET"
        cmbCity.AddItem "MAKILALA"
        cmbCity.AddItem "MATALAM"
        cmbCity.AddItem "MIDSAYAP"
        cmbCity.AddItem "PIGKAWAYAN"
        cmbCity.AddItem "PIKIT"
        cmbCity.AddItem "PRESIDENT ROXAS"
        cmbCity.AddItem "TULUNAN"
    Case "SARANGANI"
        cmbCity.AddItem "ALABEL"
        cmbCity.AddItem "GLAN"
        cmbCity.AddItem "KIAMBA"
        cmbCity.AddItem "MAASIM"
        cmbCity.AddItem "MAITUM"
        cmbCity.AddItem "MALAPATAN"
        cmbCity.AddItem "MALUNGON"
    Case "SOUTH COTABATO"
        cmbCity.AddItem "BANGA"
        cmbCity.AddItem "GENERAL SANTOS CITY(DADIANGAS)"
        cmbCity.AddItem "KORONADAL CITY"
        cmbCity.AddItem "LAKE SEBU"
        cmbCity.AddItem "NORALA"
        cmbCity.AddItem "POLOMOLOK"
        cmbCity.AddItem "SANTO NIÑO"
        cmbCity.AddItem "SURALLAH"
        cmbCity.AddItem "TBOLI"
        cmbCity.AddItem "TAMPAKAN"
        cmbCity.AddItem "TANTANGAN"
        cmbCity.AddItem "TUPI"
    Case "SULTAN KUDARAT"
        cmbCity.AddItem "BAGUMBAYAN"
        cmbCity.AddItem "COLUMBIO"
        cmbCity.AddItem "ESPERANZA(AMPATUAN)"
        cmbCity.AddItem "ISULAN"
        cmbCity.AddItem "KALAMANSIG"
        cmbCity.AddItem "LAMBAYONG"
        cmbCity.AddItem "LEBAK(SALAMAN)"
        cmbCity.AddItem "LUTAYAN"
        cmbCity.AddItem "PALIMBANG"
        cmbCity.AddItem "PRES. QUIRINO"
        cmbCity.AddItem "SEN. NINOY AQUINO"
        cmbCity.AddItem "TACURONG"
    Case "AKLAN"
        cmbCity.AddItem "ALTAVAS"
        cmbCity.AddItem "BALETE"
        cmbCity.AddItem "BANGA"
        cmbCity.AddItem "BATAN"
        cmbCity.AddItem "BURUANGA"
        cmbCity.AddItem "IBAJAY"
        cmbCity.AddItem "KALIBO"
        cmbCity.AddItem "LEZO"
        cmbCity.AddItem "LIBACAO"
        cmbCity.AddItem "MADALAG"
        cmbCity.AddItem "MAKATO"
        cmbCity.AddItem "MALAY"
        cmbCity.AddItem "MALINAO"
        cmbCity.AddItem "NABAS"
        cmbCity.AddItem "NEW WASHINGTON"
        cmbCity.AddItem "NUMANCIA"
        cmbCity.AddItem "TANGALAN"
    Case "ANTIQUE"
        cmbCity.AddItem "ANINI-Y"
        cmbCity.AddItem "BARBAZA"
        cmbCity.AddItem "BELISON"
        cmbCity.AddItem "BUGASONG"
        cmbCity.AddItem "CALUYA"
        cmbCity.AddItem "CULASI"
        cmbCity.AddItem "HAMTIC"
        cmbCity.AddItem "LAUA-AN"
        cmbCity.AddItem "LIBERTAD"
        cmbCity.AddItem "PANDAN"
        cmbCity.AddItem "PATNONGON"
        cmbCity.AddItem "SAN JOSE"
        cmbCity.AddItem "SAN REMIGIO"
        cmbCity.AddItem "SEBASTE"
        cmbCity.AddItem "SIBALOM"
        cmbCity.AddItem "TIBIAO"
        cmbCity.AddItem "TOBIAS FORNIER(DAO)"
        cmbCity.AddItem "VALDERAMA"
    Case "CAPIZ"
        cmbCity.AddItem "CUARTERO"
        cmbCity.AddItem "DAO"
        cmbCity.AddItem "DUMALAG"
        cmbCity.AddItem "DUMARAO"
        cmbCity.AddItem "IVISAN"
        cmbCity.AddItem "JAMINDAN"
        cmbCity.AddItem "MA-AYON"
        cmbCity.AddItem "MAMBUSAO"
        cmbCity.AddItem "PANAY"
        cmbCity.AddItem "PANITAN"
        cmbCity.AddItem "PILAR"
        cmbCity.AddItem "PONTEVEDRA"
        cmbCity.AddItem "PRESIDENT ROXAS"
        cmbCity.AddItem "ROXAS CITY"
        cmbCity.AddItem "SAPIAN"
        cmbCity.AddItem "SIGMA"
        cmbCity.AddItem "TAPAZ"
    Case "GUIMARAS"
        cmbCity.AddItem "BUENAVISTA"
        cmbCity.AddItem "JORDAN"
        cmbCity.AddItem "NUEVA VALENCIA"
        cmbCity.AddItem "SAN LORENZO"
        cmbCity.AddItem "SIBUNAG"
    Case "ILOILO"
        cmbCity.AddItem "AJUY"
        cmbCity.AddItem "ALIMODIAN"
        cmbCity.AddItem "ANILAO"
        cmbCity.AddItem "BADIANGAN"
        cmbCity.AddItem "BALASAN"
        cmbCity.AddItem "BANATE"
        cmbCity.AddItem "BAROTAC NUEVO"
        cmbCity.AddItem "BAROTAC VIEJO"
        cmbCity.AddItem "BATAD"
        cmbCity.AddItem "BINGAWAN"
        cmbCity.AddItem "CABATUAN"
        cmbCity.AddItem "CALINOG"
        cmbCity.AddItem "CARLES"
        cmbCity.AddItem "CONCEPCION"
        cmbCity.AddItem "DINGLE"
        cmbCity.AddItem "DUENAS"
        cmbCity.AddItem "DUMANGAS"
        cmbCity.AddItem "ESTANCIA"
        cmbCity.AddItem "GUIMBAL"
        cmbCity.AddItem "IGBARAS"
        cmbCity.AddItem "ILOILO CITY"
        cmbCity.AddItem "JANIUAY"
        cmbCity.AddItem "LAMBUNAO"
        cmbCity.AddItem "LEGANES"
        cmbCity.AddItem "LEMERY"
        cmbCity.AddItem "LEON"
        cmbCity.AddItem "MAASIN"
        cmbCity.AddItem "MIAGAO"
        cmbCity.AddItem "MINA"
        cmbCity.AddItem "NEW LUCENA"
        cmbCity.AddItem "OTON"
        cmbCity.AddItem "PASSI"
        cmbCity.AddItem "PAVIA"
        cmbCity.AddItem "POTOTAN"
        cmbCity.AddItem "SAN DIONISIO"
        cmbCity.AddItem "SAN ENRIQUE"
        cmbCity.AddItem "SAN JOAQUIN"
        cmbCity.AddItem "SAN MIGUEL"
        cmbCity.AddItem "SAN RAFAEL"
        cmbCity.AddItem "SANTA BARBARA"
        cmbCity.AddItem "SARA"
        cmbCity.AddItem "TIGBAUAN"
        cmbCity.AddItem "TUBUNGAN"
        cmbCity.AddItem "ZARRAGA"
    Case "NEGROS OCCIDENTAL"
        cmbCity.AddItem "BACOLOD CITY"
        cmbCity.AddItem "BAGO CITY"
        cmbCity.AddItem "BINALBAGAN"
        cmbCity.AddItem "CADIZ CITY"
        cmbCity.AddItem "CALATRAVA"
        cmbCity.AddItem "CANDONI"
        cmbCity.AddItem "CAUAYAN"
        cmbCity.AddItem "DON SALVADOR"
        cmbCity.AddItem "ENRIQUE MAGALONA"
        cmbCity.AddItem "ESCALANTE"
        cmbCity.AddItem "HIMAMAYLAN"
        cmbCity.AddItem "HINIGARAN"
        cmbCity.AddItem "HINOBA-AN"
        cmbCity.AddItem "ILOG"
        cmbCity.AddItem "ISABELA"
        cmbCity.AddItem "KABANKALAN"
        cmbCity.AddItem "KAUAYAN"
        cmbCity.AddItem "LA CARLOTA CITY"
        cmbCity.AddItem "LA CASTELLANA"
        cmbCity.AddItem "MANAPLA"
        cmbCity.AddItem "MOISES PADILLA"
        cmbCity.AddItem "MURCIA"
        cmbCity.AddItem "PARAISO(FABRICA)"
        cmbCity.AddItem "PONTEVEDRA"
        cmbCity.AddItem "PULUPANDAN"
        cmbCity.AddItem "SAGAY"
        cmbCity.AddItem "SALVADOR BENEDICTO"
        cmbCity.AddItem "SAN CARLOS CITY"
        cmbCity.AddItem "SAN ENRIQUE"
        cmbCity.AddItem "SILAY CITY"
        cmbCity.AddItem "SILAY HAWAIIAN CENTRAL"
        cmbCity.AddItem "SIPALAY"
        cmbCity.AddItem "TALISAY"
        cmbCity.AddItem "TOBOSO"
        cmbCity.AddItem "VALLADOLID"
        cmbCity.AddItem "VICTORIAS"
    Case "BASILAN "
        cmbCity.AddItem "ISABELA DE BASILAN - ISABELA CITY"
    Case "ZAMBOANGA SIBUGAY"
        cmbCity.AddItem "ALICA"
        cmbCity.AddItem "BUUG"
        cmbCity.AddItem "DIPLAHAN"
        cmbCity.AddItem "IMELDA"
        cmbCity.AddItem "IPIL"
        cmbCity.AddItem "KABASALAN"
        cmbCity.AddItem "MABUHAY"
        cmbCity.AddItem "MALANGAS"
        cmbCity.AddItem "NAGA"
        cmbCity.AddItem "OLUTANGA"
        cmbCity.AddItem "PAYAO"
        cmbCity.AddItem "ROSELLER LIM"
        cmbCity.AddItem "SIAY"
        cmbCity.AddItem "TALUSAN"
        cmbCity.AddItem "TITAY"
        cmbCity.AddItem "TUNGAWAN"
    Case "ZAMBOANGA DEL NORTE"
        cmbCity.AddItem "BALIGUIAN"
        cmbCity.AddItem "DAPITAN CITY"
        cmbCity.AddItem "DIPOLOG CITY"
        cmbCity.AddItem "GODOD"
        cmbCity.AddItem "GUTALAC"
        cmbCity.AddItem "JOSE DALMAN(PONOT)"
        cmbCity.AddItem "KALAWIT"
        cmbCity.AddItem "KATIPUNAN"
        cmbCity.AddItem "LA LIBERTAD"
        cmbCity.AddItem "LABASON"
        cmbCity.AddItem "LEON B. POSTIGO"
        cmbCity.AddItem "LILOY"
        cmbCity.AddItem "MANUKAN"
        cmbCity.AddItem "MUTIA"
        cmbCity.AddItem "PINAN"
        cmbCity.AddItem "POLANCO"
        cmbCity.AddItem "RIZAL"
        cmbCity.AddItem "ROXAS"
        cmbCity.AddItem "SALUG"
        cmbCity.AddItem "SERGIO OSMEÑA"
        cmbCity.AddItem "SIAYAN"
        cmbCity.AddItem "SIBUCO"
        cmbCity.AddItem "SIBUTAD"
        cmbCity.AddItem "SINDANGAN"
        cmbCity.AddItem "SIOCON"
        cmbCity.AddItem "SIRAWAY"
        cmbCity.AddItem "TAMPILISAN"
    Case "ZAMBOANGA DEL SUR"
        cmbCity.AddItem "AURORA"
        cmbCity.AddItem "BAYOG"
        cmbCity.AddItem "DIMATALING"
        cmbCity.AddItem "DINAS"
        cmbCity.AddItem "DUMALINAO"
        cmbCity.AddItem "DUMINGAG"
        cmbCity.AddItem "GUIPOS"
        cmbCity.AddItem "JOSEFINA"
        cmbCity.AddItem "KUMALARANG"
        cmbCity.AddItem "LABANGAN"
        cmbCity.AddItem "LAKEWOOD"
        cmbCity.AddItem "LAPUYAN"
        cmbCity.AddItem "MAHAYAG"
        cmbCity.AddItem "MARGO SA TUBIG"
        cmbCity.AddItem "MIDSALIP"
        cmbCity.AddItem "MOLAVE"
        cmbCity.AddItem "PAGADIAN CITY"
        cmbCity.AddItem "PITOGO"
        cmbCity.AddItem "RAMON MAGSAYSAY"
        cmbCity.AddItem "SAN MIGUEL"
        cmbCity.AddItem "SAN PABLO"
        cmbCity.AddItem "SOMINOT(DON MARIANO MARCOS)"
        cmbCity.AddItem "TABINA"
        cmbCity.AddItem "TAMBULIG"
        cmbCity.AddItem "TIGBAO"
        cmbCity.AddItem "TUKURAN"
        cmbCity.AddItem "VICENCIO SAGUN"
        cmbCity.AddItem "ZAMBOANGA CITY"
   Case "BUKIDNON"
        cmbCity.AddItem "BAUNGON"
        cmbCity.AddItem "CABANGLASAN"
        cmbCity.AddItem "DAMULOG"
        cmbCity.AddItem "DANGCAGAN"
        cmbCity.AddItem "DON CARLOS"
        cmbCity.AddItem "IMPASUGONG"
        cmbCity.AddItem "KADINGILAN"
        cmbCity.AddItem "KALILANGAN"
        cmbCity.AddItem "KIBAWE"
        cmbCity.AddItem "KITAOTAO"
        cmbCity.AddItem "LANTAPAN"
        cmbCity.AddItem "LIBONA"
        cmbCity.AddItem "MALAYBALAY CITY"
        cmbCity.AddItem "MALITBOG"
        cmbCity.AddItem "MANOLO FORTICH"
        cmbCity.AddItem "MARAMAG"
        cmbCity.AddItem "MUSUAN"
        cmbCity.AddItem "PANGANTUCAN"
        cmbCity.AddItem "PHILLIPS"
        cmbCity.AddItem "QUEZON"
        cmbCity.AddItem "SAN FERNANDO"
        cmbCity.AddItem "SUMILAO"
        cmbCity.AddItem "TALAKAG"
        cmbCity.AddItem "VALENCIA CITY"
    Case "CAMIGUIN"
        cmbCity.AddItem "CATARMAN"
        cmbCity.AddItem "GUINSILIBAN"
        cmbCity.AddItem "MAHINOG"
        cmbCity.AddItem "MAMBAJAO"
        cmbCity.AddItem "SAGAY"
    Case "LANAO DEL NORTE"
        cmbCity.AddItem "BACOLOD"
        cmbCity.AddItem "BALOI"
        cmbCity.AddItem "BAROY"
        cmbCity.AddItem "ILIGAN CITY"
        cmbCity.AddItem "KAPATAGAN"
        cmbCity.AddItem "KAROMATAN"
        cmbCity.AddItem "KAUSWAGAN"
        cmbCity.AddItem "KOLAMBOGAN"
        cmbCity.AddItem "LALA"
        cmbCity.AddItem "LINAMON"
        cmbCity.AddItem "MAGSAYSAY"
        cmbCity.AddItem "MAIGO"
        cmbCity.AddItem "MATUNGAO"
        cmbCity.AddItem "MUNAI"
        cmbCity.AddItem "NUNUNGAN"
        cmbCity.AddItem "PANTAO RAGAT"
        cmbCity.AddItem "PANTAR"
        cmbCity.AddItem "POONA PIAGAPO"
        cmbCity.AddItem "SALVADOR"
        cmbCity.AddItem "SAPAD"
        cmbCity.AddItem "TAGOLOAN"
        cmbCity.AddItem "TANGKAL"
        cmbCity.AddItem "TUBOD"
    Case "MISAMIS OCCIDENTAL"
        cmbCity.AddItem "ALORAN"
        cmbCity.AddItem "BALIANGAO"
        cmbCity.AddItem "BONIFACIO"
        cmbCity.AddItem "CALAMBA"
        cmbCity.AddItem "CLARIN"
        cmbCity.AddItem "CONCEPCION"
        cmbCity.AddItem "DON VICTORIANO"
        cmbCity.AddItem "JIMENEZ"
        cmbCity.AddItem "LOPEZ JAENA"
        cmbCity.AddItem "OROQUIETA CITY"
        cmbCity.AddItem "OZAMIS CITY"
        cmbCity.AddItem "PANAON"
        cmbCity.AddItem "PLARIDEL"
        cmbCity.AddItem "SAPANG DALAGA"
        cmbCity.AddItem "SINACABAN"
        cmbCity.AddItem "TANGUB CITY"
        cmbCity.AddItem "TUDELA"
    Case "MISAMIS ORIENTAL"
        cmbCity.AddItem "ALUBIJID"
        cmbCity.AddItem "BALINGASAG"
        cmbCity.AddItem "BALINGUAN"
        cmbCity.AddItem "BINUANGAN"
        cmbCity.AddItem "CAGAYAN DE ORO CITY"
        cmbCity.AddItem "CLAVERIA"
        cmbCity.AddItem "EL SALVADOR"
        cmbCity.AddItem "GINGOOG CITY"
        cmbCity.AddItem "GITAGUM"
        cmbCity.AddItem "INITAO"
        cmbCity.AddItem "JASAAN"
        cmbCity.AddItem "KINOGITAN"
        cmbCity.AddItem "LAGONGLONG"
        cmbCity.AddItem "LAGUINDINGAN"
        cmbCity.AddItem "LIBERTAD"
        cmbCity.AddItem "LUGAIT"
        cmbCity.AddItem "MAGSAYSAY"
        cmbCity.AddItem "MANTICAO"
        cmbCity.AddItem "MEDINA"
        cmbCity.AddItem "NAAWAN"
        cmbCity.AddItem "OPOL"
        cmbCity.AddItem "SALAY"
        cmbCity.AddItem "SUGBUNGCOGON"
        cmbCity.AddItem "TAGOLOAN"
        cmbCity.AddItem "TALISAYAN"
        cmbCity.AddItem "VILLANUEVA"
    Case "MARINDUQUE"
        cmbCity.AddItem "BOAC"
        cmbCity.AddItem "BUENAVISTA"
        cmbCity.AddItem "GASAN"
        cmbCity.AddItem "MOGPOG"
        cmbCity.AddItem "SANTA CRUZ"
        cmbCity.AddItem "TORRIJOS"
    Case "OCCIDENTAL MINDORO"
        cmbCity.AddItem "ABRA DE ILOG"
        cmbCity.AddItem "CALINTAAN"
        cmbCity.AddItem "LOOC"
        cmbCity.AddItem "LUBANG"
        cmbCity.AddItem "MAGSAYSAY"
        cmbCity.AddItem "MAMBURAO"
        cmbCity.AddItem "PALUAN"
        cmbCity.AddItem "RIZAL"
        cmbCity.AddItem "SABLAYAN"
        cmbCity.AddItem "SAN JOSE"
        cmbCity.AddItem "SANTA CRUZ"
        cmbCity.AddItem "TILIK"
    Case "ORIENTAL MINDORO"
        cmbCity.AddItem "BACO"
        cmbCity.AddItem "BANSUD"
        cmbCity.AddItem "BONGABONG"
        cmbCity.AddItem "BULALACAO"
        cmbCity.AddItem "CALAPAN"
        cmbCity.AddItem "GLORIA"
        cmbCity.AddItem "MANSALAY"
        cmbCity.AddItem "NAUJAN"
        cmbCity.AddItem "PINAMALAYAN"
        cmbCity.AddItem "POLA"
        cmbCity.AddItem "PUERTO GALERA"
        cmbCity.AddItem "ROXAS"
        cmbCity.AddItem "SAN TEODORO"
        cmbCity.AddItem "SOCORRO"
        cmbCity.AddItem "VICTORIA"
    Case "PALAWAN"
        cmbCity.AddItem "ABORLAN"
        cmbCity.AddItem "AGUTAYA"
        cmbCity.AddItem "ARACELI"
        cmbCity.AddItem "BALABAC"
        cmbCity.AddItem "BATARAZA"
        cmbCity.AddItem "BROOKES POINT"
        cmbCity.AddItem "BUSUANGA"
        cmbCity.AddItem "CAGAYANCILLO"
        cmbCity.AddItem "CORON"
        cmbCity.AddItem "CULION"
        cmbCity.AddItem "CUYO"
        cmbCity.AddItem "DUMARAN"
        cmbCity.AddItem "EL NIDO(BAQUIT)"
        cmbCity.AddItem "IWAHIG PENAL COLONY"
        cmbCity.AddItem "KALAYAAN"
        cmbCity.AddItem "LINAPACAN"
        cmbCity.AddItem "MAGSAYSAY"
        cmbCity.AddItem "NARRA(PANACAN)"
        cmbCity.AddItem "PUERTO PRINCESA CITY"
        cmbCity.AddItem "QUEZON"
        cmbCity.AddItem "RIZAL(MARCOS)"
        cmbCity.AddItem "ROXAS"
        cmbCity.AddItem "SAN VICENTE"
        cmbCity.AddItem "SOFRONIO ESPANOLA"
        cmbCity.AddItem "TAYTAY"
    Case "ROMBLON"
        cmbCity.AddItem "ALCANTARA"
        cmbCity.AddItem "BANTON(JONES)"
        cmbCity.AddItem "CAJIDIOCAN"
        cmbCity.AddItem "CALATRAVA"
        cmbCity.AddItem "CONCEPCION"
        cmbCity.AddItem "CORCUERA"
        cmbCity.AddItem "FERROL"
        cmbCity.AddItem "IMELDA"
        cmbCity.AddItem "LOOC"
        cmbCity.AddItem "MAGDIWANG"
        cmbCity.AddItem "ODIONGAN"
        cmbCity.AddItem "ROMBLON"
        cmbCity.AddItem "SAN AGUSTIN"
        cmbCity.AddItem "SAN ANDRES"
        cmbCity.AddItem "SAN FERNANDO"
        cmbCity.AddItem "SAN JOSE"
        cmbCity.AddItem "SANTA FE"
        cmbCity.AddItem "SANTA MARIA"
    Case "ILOCOS NORTE"
        cmbCity.AddItem "ADAMS"
        cmbCity.AddItem "BACARRA"
        cmbCity.AddItem "BADOC"
        cmbCity.AddItem "BANGUI"
        cmbCity.AddItem "BANNA(ESPIRITU)"
        cmbCity.AddItem "BATAC"
        cmbCity.AddItem "BURGOS"
        cmbCity.AddItem "CARASI"
        cmbCity.AddItem "CURRIMAO"
        cmbCity.AddItem "DINGRAS"
        cmbCity.AddItem "DUMALNEG"
        cmbCity.AddItem "LAOAG CITY"
        cmbCity.AddItem "MARCOS"
        cmbCity.AddItem "NUEVA ERA"
        cmbCity.AddItem "PAGUDPUD"
        cmbCity.AddItem "PAOAY"
        cmbCity.AddItem "PASUQUIN"
        cmbCity.AddItem "PIDDIG"
        cmbCity.AddItem "PINILI"
        cmbCity.AddItem "SAN NICOLAS"
        cmbCity.AddItem "SARRAT"
        cmbCity.AddItem "SOLSONA"
        cmbCity.AddItem "VINTAR"
    Case "ILOCOS SUR"
        cmbCity.AddItem "ALILEM"
        cmbCity.AddItem "BANAYOYO"
        cmbCity.AddItem "BANTAY"
        cmbCity.AddItem "BURGOS"
        cmbCity.AddItem "CABUGAO"
        cmbCity.AddItem "CANDON CITY"
        cmbCity.AddItem "CAOAYAN"
        cmbCity.AddItem "CERVANTES"
        cmbCity.AddItem "GALIMUYOD"
        cmbCity.AddItem "GREGORIO DEL PILAR"
        cmbCity.AddItem "LIDLIDDA"
        cmbCity.AddItem "MAGSINGAL"
        cmbCity.AddItem "NAGBUKEL"
        cmbCity.AddItem "NARVACAN"
        cmbCity.AddItem "QUIRINO(ANGKAKI)"
        cmbCity.AddItem "SALCEDO(BAUGEN)"
        cmbCity.AddItem "SAN EMILIO"
        cmbCity.AddItem "SAN ESTEBAN"
        cmbCity.AddItem "SAN ILDEFONSO"
        cmbCity.AddItem "SAN JUAN(LAPOG)"
        cmbCity.AddItem "SAN VICENTE"
        cmbCity.AddItem "SANTA"
        cmbCity.AddItem "SANTA CATALINA"
        cmbCity.AddItem "SANTA CRUZ"
        cmbCity.AddItem "SANTA LUCIA"
        cmbCity.AddItem "SANTA MARIA"
        cmbCity.AddItem "SANTIAGO"
        cmbCity.AddItem "SANTO DOMINGO"
        cmbCity.AddItem "SIGAY"
        cmbCity.AddItem "SINAIT"
        cmbCity.AddItem "SUGPON"
        cmbCity.AddItem "SUYO"
        cmbCity.AddItem "TAGUDIN"
        cmbCity.AddItem "VIGAN CITY"
    Case "LA UNION"
        cmbCity.AddItem "AGOO"
        cmbCity.AddItem "ARINGAY"
        cmbCity.AddItem "BACNOTAN"
        cmbCity.AddItem "BAGULIN"
        cmbCity.AddItem "BALAOAN"
        cmbCity.AddItem "BANGAR"
        cmbCity.AddItem "BAUANG"
        cmbCity.AddItem "BURGOS"
        cmbCity.AddItem "CABA"
        cmbCity.AddItem "DAMORTIS"
        cmbCity.AddItem "LUNA"
        cmbCity.AddItem "NAGUILIAN"
        cmbCity.AddItem "PUGO"
        cmbCity.AddItem "ROSARIO"
        cmbCity.AddItem "SAN FERNANDO CITY"
        cmbCity.AddItem "SAN GABRIEL"
        cmbCity.AddItem "SAN JUAN"
        cmbCity.AddItem "SANTO TOMAS"
        cmbCity.AddItem "SANTOL"
        cmbCity.AddItem "SUDIPEN"
        cmbCity.AddItem "TUBAO"
    Case "PANGASINAN"
        cmbCity.AddItem "AGNO"
        cmbCity.AddItem "AGUILAR"
        cmbCity.AddItem "ALAMINOS"
        cmbCity.AddItem "ALCALA"
        cmbCity.AddItem "ANDA"
        cmbCity.AddItem "ASINGAN"
        cmbCity.AddItem "BALUNGAO"
        cmbCity.AddItem "BANI"
        cmbCity.AddItem "BASISTA"
        cmbCity.AddItem "BAUTISTA"
        cmbCity.AddItem "BAYAMBANG"
        cmbCity.AddItem "BINALONAN"
        cmbCity.AddItem "BINMALEY"
        cmbCity.AddItem "BOLINAO"
        cmbCity.AddItem "BUGALLON"
        cmbCity.AddItem "BURGOS"
        cmbCity.AddItem "CALASIAO"
        cmbCity.AddItem "DAGUPAN CITY"
        cmbCity.AddItem "DASOL"
        cmbCity.AddItem "INFANTA"
        cmbCity.AddItem "LABRADOR"
        cmbCity.AddItem "LAOAC"
        cmbCity.AddItem "LINGAYEN"
        cmbCity.AddItem "MABINI"
        cmbCity.AddItem "MALASIQUI"
        cmbCity.AddItem "MANAOAG"
        cmbCity.AddItem "MANGALDAN"
        cmbCity.AddItem "MANGATAREM"
        cmbCity.AddItem "MAPANDAN"
        cmbCity.AddItem "NATIVIDAD"
        cmbCity.AddItem "POZORRUBIO"
        cmbCity.AddItem "ROSALES"
        cmbCity.AddItem "SAN CARLOS CITY"
        cmbCity.AddItem "SAN FABIAN"
        cmbCity.AddItem "SAN JACINTO"
        cmbCity.AddItem "SAN MANUEL"
        cmbCity.AddItem "SAN NICOLAS"
        cmbCity.AddItem "SAN QUINTIN"
        cmbCity.AddItem "SANTA BARBARA"
        cmbCity.AddItem "SANTA MARIA"
        cmbCity.AddItem "SANTO TOMAS"
        cmbCity.AddItem "SISON"
        cmbCity.AddItem "SUAL"
        cmbCity.AddItem "TAYUG"
        cmbCity.AddItem "UMINGAN"
        cmbCity.AddItem "URBIZTONDO"
        cmbCity.AddItem "URDANETA"
        cmbCity.AddItem "VILLASIS"
    Case "DAVAO ORIENTAL"
        cmbCity.AddItem "BAGANGA"
        cmbCity.AddItem "BANAYBANAY"
        cmbCity.AddItem "BOSTON"
        cmbCity.AddItem "CARAGA"
        cmbCity.AddItem "CATEEL"
        cmbCity.AddItem "GOVERNOR GENEROSO"
        cmbCity.AddItem "LUPON"
        cmbCity.AddItem "MANAY"
        cmbCity.AddItem "MATI"
        cmbCity.AddItem "SAN ISIDRO"
        cmbCity.AddItem "TARRAGONA"
    Case "DAVAO DEL NORTE"
        cmbCity.AddItem "ASUNCION"
        cmbCity.AddItem "BABAK"
        cmbCity.AddItem "BRAULIO E. DUJALI"
        cmbCity.AddItem "CARMEN"
        cmbCity.AddItem "ISLAND GARDEN CITY OF SAMAL"
        cmbCity.AddItem "KAPALONG"
        cmbCity.AddItem "KAPUTIAN"
        cmbCity.AddItem "NEW CORELLA"
        cmbCity.AddItem "PANABO CITY"
        cmbCity.AddItem "SAN ISIDRO"
        cmbCity.AddItem "SANTO TOMAS"
        cmbCity.AddItem "TAGUM CITY"
        cmbCity.AddItem "TALAINGOD"
    Case "DAVAO DEL SUR"
        cmbCity.AddItem "BANSALAN"
        cmbCity.AddItem "DAVAO CITY"
        cmbCity.AddItem "DIGOS CITY"
        cmbCity.AddItem "DON MARCELINO"
        cmbCity.AddItem "HAGONOY"
        cmbCity.AddItem "JOSE ABAD SANTOS"
        cmbCity.AddItem "KIBLAWAN"
        cmbCity.AddItem "MAGSAYSAY"
        cmbCity.AddItem "MALALAG"
        cmbCity.AddItem "MALITA"
        cmbCity.AddItem "MATANAO"
        cmbCity.AddItem "PADADA"
        cmbCity.AddItem "SANTA CRUZ"
        cmbCity.AddItem "SANTA MARIA"
        cmbCity.AddItem "SARANGANI"
        cmbCity.AddItem "SULOP"
    Case "PROVINCE OF DAVAO DE ORO"
        cmbCity.AddItem "COMPOSTELA"
        cmbCity.AddItem "LAAK(SAN VICENTE)"
        cmbCity.AddItem "MABINI(DOÑA ALICIA)"
        cmbCity.AddItem "MACO"
        cmbCity.AddItem "MARAGUSAN(SAN MARIANO)"
        cmbCity.AddItem "MAWAB"
        cmbCity.AddItem "MONKAYO"
        cmbCity.AddItem "MONTEVISTA"
        cmbCity.AddItem "NABUNTURAN"
        cmbCity.AddItem "NEW BATAAN"
        cmbCity.AddItem "PANTUKAN"
    Case "BILIRAN"
        cmbCity.AddItem "ALMERA"
        cmbCity.AddItem "BILIRAN"
        cmbCity.AddItem "CABUCGAYAN"
        cmbCity.AddItem "CAIBIRAN"
        cmbCity.AddItem "CULABA"
        cmbCity.AddItem "KAWAYAN"
        cmbCity.AddItem "MARIPIPI"
        cmbCity.AddItem "NAVAL"
    Case "EASTERN SAMAR"
        cmbCity.AddItem "ARTECHE"
        cmbCity.AddItem "BALANGIGA"
        cmbCity.AddItem "BALANGKAYAN"
        cmbCity.AddItem "BORONGAN"
        cmbCity.AddItem "CAN-AVID"
        cmbCity.AddItem "DOLORES"
        cmbCity.AddItem "GENERAL MACARTHUR"
        cmbCity.AddItem "GIPORLOS"
        cmbCity.AddItem "GUIUAN"
        cmbCity.AddItem "HERNANI"
        cmbCity.AddItem "JIPAPAD"
        cmbCity.AddItem "LAWAAN"
        cmbCity.AddItem "LLORENTE"
        cmbCity.AddItem "MASLOG"
        cmbCity.AddItem "MAYDOLONG"
        cmbCity.AddItem "MERCEDES"
        cmbCity.AddItem "ORAS"
        cmbCity.AddItem "QUINAPONDAN"
        cmbCity.AddItem "SALCEDO"
        cmbCity.AddItem "SAN JULIAN"
        cmbCity.AddItem "SAN POLICARPO"
        cmbCity.AddItem "SULAT"
        cmbCity.AddItem "TAFT"
    Case "LEYTE"
        cmbCity.AddItem "ABUYOG"
        cmbCity.AddItem "ALANGALANG"
        cmbCity.AddItem "ALBUERA"
        cmbCity.AddItem "BABATNGON"
        cmbCity.AddItem "BARUGO"
        cmbCity.AddItem "BATO"
        cmbCity.AddItem "BAYBAY"
        cmbCity.AddItem "BURAUEN"
        cmbCity.AddItem "CALUBIAN"
        cmbCity.AddItem "CAPOOCAN"
        cmbCity.AddItem "CARIGARA"
        cmbCity.AddItem "DAGAMI"
        cmbCity.AddItem "DULAG"
        cmbCity.AddItem "HILONGOS"
        cmbCity.AddItem "HINDANG"
        cmbCity.AddItem "INOPACAN"
        cmbCity.AddItem "ISABEL"
        cmbCity.AddItem "JARO"
        cmbCity.AddItem "JAVIER"
        cmbCity.AddItem "JULITA"
        cmbCity.AddItem "KANANGA"
        cmbCity.AddItem "LA PAZ"
        cmbCity.AddItem "LEYTE"
        cmbCity.AddItem "MACARTHUR"
        cmbCity.AddItem "MAHAPLAG"
        cmbCity.AddItem "MATAG-OB"
        cmbCity.AddItem "MATALOM"
        cmbCity.AddItem "MAYORGA"
        cmbCity.AddItem "MERIDA"
        cmbCity.AddItem "ORMOC CITY"
        cmbCity.AddItem "PALO"
        cmbCity.AddItem "PALOMPON"
        cmbCity.AddItem "PASTRANA"
        cmbCity.AddItem "SAN ISIDRO"
        cmbCity.AddItem "SAN MIGUEL"
        cmbCity.AddItem "SANTA FE"
        cmbCity.AddItem "TABANGO"
        cmbCity.AddItem "TABONTABON"
        cmbCity.AddItem "TACLOBAN CITY"
        cmbCity.AddItem "TANAUAN"
        cmbCity.AddItem "TOLOSA"
        cmbCity.AddItem "TUNGA"
        cmbCity.AddItem "VILLABA"
    Case "NORTHERN SAMAR"
        cmbCity.AddItem "ALLEN"
        cmbCity.AddItem "BIRI"
        cmbCity.AddItem "BOBON"
        cmbCity.AddItem "CAPUL"
        cmbCity.AddItem "CATARMAN"
        cmbCity.AddItem "CATUBIG"
        cmbCity.AddItem "GAMAY"
        cmbCity.AddItem "LAOANG"
        cmbCity.AddItem "LAPINEG"
        cmbCity.AddItem "LAS NAVAS"
        cmbCity.AddItem "LAVEZARES"
        cmbCity.AddItem "LOPE DE VEGA"
        cmbCity.AddItem "MAPANAS"
        cmbCity.AddItem "MONDRAGON"
        cmbCity.AddItem "PALAPAG"
        cmbCity.AddItem "PAMBUJAN"
        cmbCity.AddItem "ROSARIO"
        cmbCity.AddItem "SAN ANTONIO"
        cmbCity.AddItem "SAN ISIDRO"
        cmbCity.AddItem "SAN JOSE"
        cmbCity.AddItem "SAN ROQUE"
        cmbCity.AddItem "SAN VICENTE"
        cmbCity.AddItem "SILVINO LUBOS"
        cmbCity.AddItem "VICTORIA"
    Case "SOUTHERN LEYTE"
        cmbCity.AddItem "ANAHAWAN"
        cmbCity.AddItem "BONTOC"
        cmbCity.AddItem "HINUNANGAN"
        cmbCity.AddItem "HINUNDAYAN"
        cmbCity.AddItem "LIBAGON"
        cmbCity.AddItem "LILOAN"
        cmbCity.AddItem "LIMASAWA"
        cmbCity.AddItem "MAASIN"
        cmbCity.AddItem "MACROHON"
        cmbCity.AddItem "MALITBOG"
        cmbCity.AddItem "PADRE BURGOS"
        cmbCity.AddItem "PINTUYAN"
        cmbCity.AddItem "SAN FRANCISCO"
        cmbCity.AddItem "SAN JUAN(CABALIAN)"
        cmbCity.AddItem "SAN RICARDO"
        cmbCity.AddItem "SILAGO"
        cmbCity.AddItem "SOGOD"
        cmbCity.AddItem "ST.BERNARD"
        cmbCity.AddItem "TOMAS OPPUS"
    Case "WESTERN SAMAR"
        cmbCity.AddItem "ALMAGRO"
        cmbCity.AddItem "BASEY"
        cmbCity.AddItem "CALBAYOG CITY"
        cmbCity.AddItem "CALBIGA"
        cmbCity.AddItem "CATBALOGAN"
        cmbCity.AddItem "DARAM"
        cmbCity.AddItem "GANDARA"
        cmbCity.AddItem "HINBANGAN"
        cmbCity.AddItem "JIABONG"
        cmbCity.AddItem "MARABUT"
        cmbCity.AddItem "MATUGUINAO"
        cmbCity.AddItem "MOTIONG"
        cmbCity.AddItem "PAGSANGHAN"
        cmbCity.AddItem "PARANAS"
        cmbCity.AddItem "PINABACDAO"
        cmbCity.AddItem "SAN JORGE"
        cmbCity.AddItem "SAN JOSE DE BAUAN"
        cmbCity.AddItem "SAN SEBASTIAN"
        cmbCity.AddItem "STA. MARGARITA"
        cmbCity.AddItem "STA. RITA"
        cmbCity.AddItem "STO. NINO"
        cmbCity.AddItem "TAGAPULAN"
        cmbCity.AddItem "TALARORA"
        cmbCity.AddItem "TARANGNAN"
        cmbCity.AddItem "VILLAREAL"
        cmbCity.AddItem "WRIGHT"
        cmbCity.AddItem "ZUMARRAGA"
    Case "ABRA"
        cmbCity.AddItem "BANGUED"
        cmbCity.AddItem "BOLINEY"
        cmbCity.AddItem "BUCAY"
        cmbCity.AddItem "BUCLOC"
        cmbCity.AddItem "DAGUIOMAN"
        cmbCity.AddItem "DANGLAS"
        cmbCity.AddItem "DOLORES"
        cmbCity.AddItem "LA PAZ"
        cmbCity.AddItem "LACUB"
        cmbCity.AddItem "LAGANGILAN"
        cmbCity.AddItem "LAGAYAN"
        cmbCity.AddItem "LANGIDEN"
        cmbCity.AddItem "LICUAN (BAAY)"
        cmbCity.AddItem "LUBA"
        cmbCity.AddItem "MALIBCONG"
        cmbCity.AddItem "MANABO"
        cmbCity.AddItem "PEÑARRUBIA"
        cmbCity.AddItem "PIDIGAN"
        cmbCity.AddItem "PILAR"
        cmbCity.AddItem "SALLAPADAN"
        cmbCity.AddItem "SAN ISIDRO"
        cmbCity.AddItem "SAN JUAN"
        cmbCity.AddItem "SAN QUINTIN"
        cmbCity.AddItem "TAYUM"
        cmbCity.AddItem "TINEG"
        cmbCity.AddItem "TUBO"
        cmbCity.AddItem "VILLAVICIOSA"
    Case "APAYAO"
        cmbCity.AddItem "CALANASAN"
        cmbCity.AddItem "CONNER"
        cmbCity.AddItem "FLORA"
        cmbCity.AddItem "KABUGAO"
        cmbCity.AddItem "LUNA"
        cmbCity.AddItem "PUDTOL"
        cmbCity.AddItem "SANTA MARCELA"
    Case "BENGUET"
        cmbCity.AddItem "ATOK"
        cmbCity.AddItem "BAGUIO CITY"
        cmbCity.AddItem "BAKUN"
        cmbCity.AddItem "BOKOD"
        cmbCity.AddItem "BUGUIAS"
        cmbCity.AddItem "ITOGON"
        cmbCity.AddItem "KABAYAN"
        cmbCity.AddItem "KAPANGAN"
        cmbCity.AddItem "KIBUNGAN"
        cmbCity.AddItem "LA TRINIDAD"
        cmbCity.AddItem "LEPANTO"
        cmbCity.AddItem "MANKAYAN"
        cmbCity.AddItem "PHILIPPINE MILITARY ACADEMY, BAGUIO CITY"
        cmbCity.AddItem "SABLAN"
        cmbCity.AddItem "TUBA"
        cmbCity.AddItem "TUBLAY"
    Case "IFUGAO"
        cmbCity.AddItem "AGUINALDO"
        cmbCity.AddItem "ALFONSO LISTA(POTIA)"
        cmbCity.AddItem "ASIPULO"
        cmbCity.AddItem "BANAUE"
        cmbCity.AddItem "HINGYON"
        cmbCity.AddItem "HUNGDUAN"
        cmbCity.AddItem "KIANGAN"
        cmbCity.AddItem "LAGAWE"
        cmbCity.AddItem "LAMUT"
        cmbCity.AddItem "MAYOYAO(MAYAOYAO)"
        cmbCity.AddItem "TINOC"
    Case "KALINGA"
        cmbCity.AddItem "BALBALAN"
        cmbCity.AddItem "LIWAN(RIZAL)"
        cmbCity.AddItem "LUBUAGAN"
        cmbCity.AddItem "PASIL"
        cmbCity.AddItem "PINUKPUK"
        cmbCity.AddItem "TABUK"
        cmbCity.AddItem "TANUDAN"
        cmbCity.AddItem "TINGLAYAN"
    Case "MT.PROVINCE"
        cmbCity.AddItem "BARLIG"
        cmbCity.AddItem "BAUKO"
        cmbCity.AddItem "BESAO"
        cmbCity.AddItem "BONTOC"
        cmbCity.AddItem "NATONIN"
        cmbCity.AddItem "PARACELIS"
        cmbCity.AddItem "SABANGAN"
        cmbCity.AddItem "SADANGA"
        cmbCity.AddItem "SAGADA"
        cmbCity.AddItem "TADIAN"
    Case "BATANGAS"
        cmbCity.AddItem "AGONCILLO"
        cmbCity.AddItem "ALITAGTAG"
        cmbCity.AddItem "BALAYAN"
        cmbCity.AddItem "BALETE"
        cmbCity.AddItem "BATANGAS CITY"
        cmbCity.AddItem "BAUAN"
        cmbCity.AddItem "CALACA"
        cmbCity.AddItem "CALATAGAN, INC. PUNTA BALUARTE"
        cmbCity.AddItem "CUENCA"
        cmbCity.AddItem "FERNANDO AIRBASE"
        cmbCity.AddItem "IBAAN"
        cmbCity.AddItem "LAREL, INCL. DIOKNO HIGHWAY"
        cmbCity.AddItem "LEMERY"
        cmbCity.AddItem "LIAN, INC. MATABUNGKAY"
        cmbCity.AddItem "LIPA CITY"
        cmbCity.AddItem "LOBO, INC. LAIYA"
        cmbCity.AddItem "MABINI"
        cmbCity.AddItem "MALVAR"
        cmbCity.AddItem "MATAAS NA KAHOY"
        cmbCity.AddItem "NASUGBU, INCL. PUNTA FUEGO AND CALARUEGA"
        cmbCity.AddItem "PADRE GARCIA"
        cmbCity.AddItem "ROSARIO"
        cmbCity.AddItem "SAN JOSE"
        cmbCity.AddItem "SAN JUAN"
        cmbCity.AddItem "SAN LUIS"
        cmbCity.AddItem "SAN NICOLAS"
        cmbCity.AddItem "SAN PASCUAL"
        cmbCity.AddItem "SANTA TERESITA"
        cmbCity.AddItem "SANTO TOMAS"
        cmbCity.AddItem "TAAL"
        cmbCity.AddItem "TALISAY CITY"
        cmbCity.AddItem "TANAUAN CITY"
        cmbCity.AddItem "TAYSAN"
        cmbCity.AddItem "TINGLOY"
        cmbCity.AddItem "TUY"
    Case "CAVITE"
        cmbCity.AddItem "ALFONSO"
        cmbCity.AddItem "AMADEO"
        cmbCity.AddItem "BACOOR"
        cmbCity.AddItem "CARMONA"
        cmbCity.AddItem "CAVITE CITY"
        cmbCity.AddItem "CORREGIDOR ISLAND"
        cmbCity.AddItem "DASMARINAS RESETTLEMENT AREA"
        cmbCity.AddItem "DASMARIÑAS"
        cmbCity.AddItem "GENERAL EMILIO AGUINALDO (BAILEN)"
        cmbCity.AddItem "GENERAL MARIANO ALVAREZ"
        cmbCity.AddItem "GENERAL TRIAS"
        cmbCity.AddItem "IMUS"
        cmbCity.AddItem "INDANG"
        cmbCity.AddItem "KAWIT"
        cmbCity.AddItem "MAGALLANES"
        cmbCity.AddItem "MARAGONDON"
        cmbCity.AddItem "MENDEZ (MENDEZ-NUÑEZ)"
        cmbCity.AddItem "NAIC"
        cmbCity.AddItem "NOVELETA"
        cmbCity.AddItem "ROSARIO"
        cmbCity.AddItem "SANGLEY POINT NAVAL BASE"
        cmbCity.AddItem "SILANG"
        cmbCity.AddItem "TAGAYTAY CITY"
        cmbCity.AddItem "TANZA"
        cmbCity.AddItem "TERNATE INCL. CAYLABNE BAY & PUERTO AZUL"
        cmbCity.AddItem "TRECE MARTIRES CITY"
    Case "LAGUNA"
        cmbCity.AddItem "ALAMINOS"
        cmbCity.AddItem "BAY"
        cmbCity.AddItem "BINAN"
        cmbCity.AddItem "BOTOCAN"
        cmbCity.AddItem "CABUYAO"
        cmbCity.AddItem "CALAMBA CITY"
        cmbCity.AddItem "CALAUAN"
        cmbCity.AddItem "CAMP VICENTE LIM"
        cmbCity.AddItem "CANUBANG, CALAMBA CITY"
        cmbCity.AddItem "CAVINTI"
        cmbCity.AddItem "FAMY"
        cmbCity.AddItem "KALAYAAN"
        cmbCity.AddItem "LILIW"
        cmbCity.AddItem "LOS BAÑOS"
        cmbCity.AddItem "LUISIANA"
        cmbCity.AddItem "LUMBAN"
        cmbCity.AddItem "MABITAC"
        cmbCity.AddItem "MAGDALENA"
        cmbCity.AddItem "MAJAYJAY"
        cmbCity.AddItem "NAGCARLAN"
        cmbCity.AddItem "PAETE"
        cmbCity.AddItem "PAGSANJAN"
        cmbCity.AddItem "PAKIL"
        cmbCity.AddItem "PANGIL"
        cmbCity.AddItem "PILA"
        cmbCity.AddItem "RIZAL"
        cmbCity.AddItem "SAN PABLO CITY"
        cmbCity.AddItem "SAN PEDRO"
        cmbCity.AddItem "SANTA CRUZ"
        cmbCity.AddItem "SANTA MARIA"
        cmbCity.AddItem "SANTA ROSA CITY"
        cmbCity.AddItem "SINILOAN"
        cmbCity.AddItem "UNIVERSITY OF THE PHILIPPINES-LOS BANOS"
        cmbCity.AddItem "VICTORIA"
    Case "QUEZON"
        cmbCity.AddItem "AGDANGAN"
        cmbCity.AddItem "ALABAT"
        cmbCity.AddItem "ATIMONAN"
        cmbCity.AddItem "BUENAVISTA"
        cmbCity.AddItem "BURDEOS"
        cmbCity.AddItem "CALAUAG"
        cmbCity.AddItem "CANDELARIA"
        cmbCity.AddItem "CATANAUAN"
        cmbCity.AddItem "DOLORES"
        cmbCity.AddItem "GENERAL ANTONIO LUNA"
        cmbCity.AddItem "GENERAL NAKAR"
        cmbCity.AddItem "GUINAYANGAN"
        cmbCity.AddItem "GUMACA"
        cmbCity.AddItem "HONDAGUA"
        cmbCity.AddItem "INFANTA"
        cmbCity.AddItem "JOMALIG"
        cmbCity.AddItem "LOPEZ"
        cmbCity.AddItem "LUCBAN"
        cmbCity.AddItem "LUCENA CITY"
        cmbCity.AddItem "MACALELON"
        cmbCity.AddItem "MAUBAN"
        cmbCity.AddItem "MULANAY"
        cmbCity.AddItem "PADRE BURGOS"
        cmbCity.AddItem "PAGBILAO"
        cmbCity.AddItem "PANUKULAN"
        cmbCity.AddItem "PATNANUNGAN"
        cmbCity.AddItem "PEREZ"
        cmbCity.AddItem "PITOGO"
        cmbCity.AddItem "PLARIDEL"
        cmbCity.AddItem "POLILIO"
        cmbCity.AddItem "PROVINCIAL CAPITOL, LUCENA CITY"
        cmbCity.AddItem "QUEZON"
        cmbCity.AddItem "REAL"
        cmbCity.AddItem "SAMPALOC"
        cmbCity.AddItem "SAN ANDRES"
        cmbCity.AddItem "SAN ANTONIO"
        cmbCity.AddItem "SAN FRANCISCO (AURORA)"
        cmbCity.AddItem "SAN NARCISO"
        cmbCity.AddItem "SARIAYA"
        cmbCity.AddItem "TAGKAWAYAN"
        cmbCity.AddItem "TAYABAS"
        cmbCity.AddItem "TIAONG"
        cmbCity.AddItem "UNISAN"
    Case "RIZAL"
        cmbCity.AddItem "ANGONO"
        cmbCity.AddItem "ANTIPOLO CITY"
        cmbCity.AddItem "BARAS"
        cmbCity.AddItem "BINANGONAN"
        cmbCity.AddItem "CAINTA"
        cmbCity.AddItem "CARDONA"
        cmbCity.AddItem "EULOGIO RODRIGUEZ (MONTALBAN)"
        cmbCity.AddItem "JALA-JALA"
        cmbCity.AddItem "MORONG"
        cmbCity.AddItem "PILILLA"
        cmbCity.AddItem "SAN MATEO"
        cmbCity.AddItem "TANAY"
        cmbCity.AddItem "TAYTAY"
        cmbCity.AddItem "TERESA"
    Case "BOHOL"
        cmbCity.AddItem "ALBURQUERQUE"
        cmbCity.AddItem "ALICIA"
        cmbCity.AddItem "ANDA"
        cmbCity.AddItem "ANTEQUERA"
        cmbCity.AddItem "BACLAYON"
        cmbCity.AddItem "BALILIHAN"
        cmbCity.AddItem "BATUAN"
        cmbCity.AddItem "BIEN UNIDO"
        cmbCity.AddItem "BILAR"
        cmbCity.AddItem "BUENAVISTA"
        cmbCity.AddItem "CALAPE"
        cmbCity.AddItem "CANDIJAY"
        cmbCity.AddItem "CARMEN"
        cmbCity.AddItem "CATIGBIAN"
        cmbCity.AddItem "CLARIN"
        cmbCity.AddItem "CORELLA"
        cmbCity.AddItem "CORTES"
        cmbCity.AddItem "DAGOHOY"
        cmbCity.AddItem "DANAO"
        cmbCity.AddItem "DAUIS"
        cmbCity.AddItem "DIMIAO"
        cmbCity.AddItem "DUERO"
        cmbCity.AddItem "GARCIA HERNANDEZ"
        cmbCity.AddItem "GUINDULMAN"
        cmbCity.AddItem "INABANGA"
        cmbCity.AddItem "JAGNA"
        cmbCity.AddItem "JETAFE"
        cmbCity.AddItem "LILA"
        cmbCity.AddItem "LOAY"
        cmbCity.AddItem "LOBOC"
        cmbCity.AddItem "LOON"
        cmbCity.AddItem "MABINI"
        cmbCity.AddItem "MARIBOJOC"
        cmbCity.AddItem "PANGLAO"
        cmbCity.AddItem "PILAR"
        cmbCity.AddItem "PRES. CARLOS P. GARCIA (PITOGO)"
        cmbCity.AddItem "SAGBAYAN"
        cmbCity.AddItem "SAN ISIDRO"
        cmbCity.AddItem "SAN MIGUEL"
        cmbCity.AddItem "SEVILLA"
        cmbCity.AddItem "SIERRA BULLONES"
        cmbCity.AddItem "SIKATUNA"
        cmbCity.AddItem "TAGBILARAN CITY"
        cmbCity.AddItem "TALIBON"
        cmbCity.AddItem "TRINIDAD"
        cmbCity.AddItem "TUBIGON"
        cmbCity.AddItem "UBAY"
        cmbCity.AddItem "VALENCIA"
    Case "CEBU"
        cmbCity.AddItem "ALCANTARA"
        cmbCity.AddItem "ALCOY"
        cmbCity.AddItem "ALEGRIA"
        cmbCity.AddItem "ALOGUINSAN"
        cmbCity.AddItem "ARGAO"
        cmbCity.AddItem "ASTURIAS"
        cmbCity.AddItem "BADIAN"
        cmbCity.AddItem "BALAMBAN"
        cmbCity.AddItem "BANTAYAN"
        cmbCity.AddItem "BARILI"
        cmbCity.AddItem "BOGO"
        cmbCity.AddItem "BOLJOON"
        cmbCity.AddItem "BORBON"
        cmbCity.AddItem "CARCAR"
        cmbCity.AddItem "CARMEN"
        cmbCity.AddItem "CATMON"
        cmbCity.AddItem "CEBU CITY"
        cmbCity.AddItem "COMPOSTELA"
        cmbCity.AddItem "CONSOLACION"
        cmbCity.AddItem "CORDOVA"
        cmbCity.AddItem "DAANBANTAYAN"
        cmbCity.AddItem "DALAGUETE"
        cmbCity.AddItem "DANAO CITY"
        cmbCity.AddItem "DUMANJUG"
        cmbCity.AddItem "GINATILAN"
        cmbCity.AddItem "LAPU-LAPU (OPON)"
        cmbCity.AddItem "LILOAN"
        cmbCity.AddItem "MACTAN AIRPORT"
        cmbCity.AddItem "MADRIDEJOS"
        cmbCity.AddItem "MALABUYOC"
        cmbCity.AddItem "MANDAUE CITY"
        cmbCity.AddItem "MEDELLIN"
        cmbCity.AddItem "MINGLANILLA"
        cmbCity.AddItem "MOALBOAL"
        cmbCity.AddItem "NAGA"
        cmbCity.AddItem "OSLOB"
        cmbCity.AddItem "PILAR"
        cmbCity.AddItem "PINAMUNGAHAN"
        cmbCity.AddItem "PORO"
        cmbCity.AddItem "RONDA"
        cmbCity.AddItem "SAMBOAN"
        cmbCity.AddItem "SAN FERNANDO"
        cmbCity.AddItem "SAN FRANCISCO"
        cmbCity.AddItem "SAN REMIGIO"
        cmbCity.AddItem "SANTA FE"
        cmbCity.AddItem "SANTANDER"
        cmbCity.AddItem "SIBONGA"
        cmbCity.AddItem "SOGOD"
        cmbCity.AddItem "TABOGON"
        cmbCity.AddItem "TABUELAN"
        cmbCity.AddItem "TALISAY CITY"
        cmbCity.AddItem "TOLEDO CITY"
        cmbCity.AddItem "TUBURAN"
        cmbCity.AddItem "TUDELA"
    Case "NEGROS ORIENTAL"
        cmbCity.AddItem "AMLAN"
        cmbCity.AddItem "AYUNGON"
        cmbCity.AddItem "BACONG"
        cmbCity.AddItem "BAIS CITY"
        cmbCity.AddItem "BASAY"
        cmbCity.AddItem "BAYAWAN"
        cmbCity.AddItem "BINDOY"
        cmbCity.AddItem "CANLAON CITY"
        cmbCity.AddItem "DAUIN"
        cmbCity.AddItem "DUMAGUETE CITY"
        cmbCity.AddItem "GUIULNGAN"
        cmbCity.AddItem "JIMALALUD"
        cmbCity.AddItem "LA LIBERTAD"
        cmbCity.AddItem "MABINAY"
        cmbCity.AddItem "MANJUYOD"
        cmbCity.AddItem "PAMPLONA"
        cmbCity.AddItem "SAN JOSE"
        cmbCity.AddItem "SIATON"
        cmbCity.AddItem "SIBULAN"
        cmbCity.AddItem "STA. CATALINA"
        cmbCity.AddItem "TANJAY"
        cmbCity.AddItem "TAYASAN"
        cmbCity.AddItem "VALENCIA"
        cmbCity.AddItem "VALLE HERMOSO"
        cmbCity.AddItem "ZAMBOANGUITA"
    Case "SIQUIJOR"
        cmbCity.AddItem "ENRIQUE VILLANUEVA"
        cmbCity.AddItem "LARENA"
        cmbCity.AddItem "LAZI"
        cmbCity.AddItem "MARIA"
        cmbCity.AddItem "SAN JUAN"
        cmbCity.AddItem "SIQUIJOR"
    Case "AURORA"
        cmbCity.AddItem "BALER"
        cmbCity.AddItem "CASIGURAN"
        cmbCity.AddItem "DILASAG"
        cmbCity.AddItem "DINALUNGAN"
        cmbCity.AddItem "DINGALAN"
        cmbCity.AddItem "DIPACULAO"
        cmbCity.AddItem "MARIA AURORA"
        cmbCity.AddItem "SAN LUIS"
    Case "BATAAN"
        cmbCity.AddItem "ABUCAY"
        cmbCity.AddItem "BAGAC"
        cmbCity.AddItem "BALANGA CITY"
        cmbCity.AddItem "DINALUPIHAN"
        cmbCity.AddItem "HERMOSA"
        cmbCity.AddItem "LAMAO"
        cmbCity.AddItem "LIMAY"
        cmbCity.AddItem "MARIVELES"
        cmbCity.AddItem "MARIVELES (BATAAN EXPORT PROCESSING ZONE)"
        cmbCity.AddItem "MORONG"
        cmbCity.AddItem "MORONG (REFUGEE PROCESSING CENTER)"
        cmbCity.AddItem "ORANI"
        cmbCity.AddItem "ORION"
        cmbCity.AddItem "PILAR"
        cmbCity.AddItem "SAMAL"
    Case "BULACAN"
        cmbCity.AddItem "ANGAT"
        cmbCity.AddItem "BALAGTAS (BIGAA)"
        cmbCity.AddItem "BALIUAG"
        cmbCity.AddItem "BOCAUE"
        cmbCity.AddItem "BULACAN"
        cmbCity.AddItem "BUSTOS"
        cmbCity.AddItem "CALUMPIT"
        cmbCity.AddItem "DONA REMEDIOS TRINIDAD"
        cmbCity.AddItem "GUIGUINTO"
        cmbCity.AddItem "HAGONOY"
        cmbCity.AddItem "MALOLOS CITY"
        cmbCity.AddItem "MARILAO"
        cmbCity.AddItem "MEYCAUAYAN"
        cmbCity.AddItem "NORZAGARAY"
        cmbCity.AddItem "OBANDO"
        cmbCity.AddItem "PANDI"
        cmbCity.AddItem "PAOMBONG"
        cmbCity.AddItem "PLARIDEL"
        cmbCity.AddItem "PULILAN"
        cmbCity.AddItem "SAN ILDEFONSO"
        cmbCity.AddItem "SAN JOSE DEL MONTE CITY"
        cmbCity.AddItem "SAN MIGUEL"
        cmbCity.AddItem "SAN RAFAEL"
        cmbCity.AddItem "SANTA MARIA"
        cmbCity.AddItem "SAPANG PALAY, MEYCAUAYAN"
    Case "NUEVA ECIJA"
        cmbCity.AddItem "ÄLIAGA"
        cmbCity.AddItem "BONGABON"
        cmbCity.AddItem "CABANATUAN CITY"
        cmbCity.AddItem "CABIAO"
        cmbCity.AddItem "CARRANGLAN"
        cmbCity.AddItem "CENTRAL LUZON STATE UNIVERSITY"
        cmbCity.AddItem "CUYAPO"
        cmbCity.AddItem "FORT MAGSAYSAY"
        cmbCity.AddItem "GABALDON"
        cmbCity.AddItem "GAPAN CITY"
        cmbCity.AddItem "GENERAL M. NATIVIDAD"
        cmbCity.AddItem "GENERAL TINIO"
        cmbCity.AddItem "GUIMBA"
        cmbCity.AddItem "JAEN"
        cmbCity.AddItem "LAUR"
        cmbCity.AddItem "LICAB"
        cmbCity.AddItem "LLANERA"
        cmbCity.AddItem "LUPAO"
        cmbCity.AddItem "MUÑOZ"
        cmbCity.AddItem "NAMPICUAN"
        cmbCity.AddItem "PALAYAN CITY"
        cmbCity.AddItem "PANTABANGAN"
        cmbCity.AddItem "PEÑARANDA"
        cmbCity.AddItem "QUEZON"
        cmbCity.AddItem "RIZAL"
        cmbCity.AddItem "SAN ANTONIO"
        cmbCity.AddItem "SAN ISIDRO"
        cmbCity.AddItem "SAN JOSE CITY"
        cmbCity.AddItem "SAN LEONARDO"
        cmbCity.AddItem "SANTA ROSA"
        cmbCity.AddItem "SANTO DOMINGO"
        cmbCity.AddItem "TALAVERA"
        cmbCity.AddItem "TALUGTOG"
        cmbCity.AddItem "ZARAGOSA"
    Case "PAMPANGA"
        cmbCity.AddItem "ANGELES CITY"
        cmbCity.AddItem "APALIT"
        cmbCity.AddItem "ARAYAT"
        cmbCity.AddItem "BACOLOR"
        cmbCity.AddItem "BASA AIRBASE"
        cmbCity.AddItem "CANDABA"
        cmbCity.AddItem "FLORIDABLANCA"
        cmbCity.AddItem "GUAGUA"
        cmbCity.AddItem "LUBAO"
        cmbCity.AddItem "MABALACAT"
        cmbCity.AddItem "MACABEBE"
        cmbCity.AddItem "MAGALANG"
        cmbCity.AddItem "MASANTOL"
        cmbCity.AddItem "MEXICO"
        cmbCity.AddItem "MINALIN"
        cmbCity.AddItem "PORAC"
        cmbCity.AddItem "SAN FERNANDO CITY"
        cmbCity.AddItem "SAN LUIS"
        cmbCity.AddItem "SAN SIMON"
        cmbCity.AddItem "SANTA ANA"
        cmbCity.AddItem "SANTA RITA"
        cmbCity.AddItem "SANTO TOMAS"
        cmbCity.AddItem "SASMUAN (SEXMOAN)"
    Case "TARLAC"
        cmbCity.AddItem "ANAO"
        cmbCity.AddItem "BAMBAN"
        cmbCity.AddItem "CAMILING"
        cmbCity.AddItem "CAPAS"
        cmbCity.AddItem "CONCEPCION"
        cmbCity.AddItem "GERONA"
        cmbCity.AddItem "LA PAZ"
        cmbCity.AddItem "MAYANTOC"
        cmbCity.AddItem "MONCADA"
        cmbCity.AddItem "PANIQUI"
        cmbCity.AddItem "PURA"
        cmbCity.AddItem "RAMOS"
        cmbCity.AddItem "SAN CLEMENTE"
        cmbCity.AddItem "SAN JOSE"
        cmbCity.AddItem "SAN MANUEL"
        cmbCity.AddItem "SAN MIGUEL"
        cmbCity.AddItem "SANTA IGNACIA"
        cmbCity.AddItem "TARLAC"
        cmbCity.AddItem "VICTORIA"
    Case "ZAMBALES"
        cmbCity.AddItem "BOTOLAN"
        cmbCity.AddItem "CABANGAN"
        cmbCity.AddItem "CANDELARIA"
        cmbCity.AddItem "CASTILLEJOS"
        cmbCity.AddItem "IBA CITY"
        cmbCity.AddItem "MASINLOC"
        cmbCity.AddItem "OLONGAPO CITY"
        cmbCity.AddItem "PALAUIG & SCARBOROUGH SHOAL"
        cmbCity.AddItem "SAN ANTONIO"
        cmbCity.AddItem "SAN FELIPE"
        cmbCity.AddItem "SAN MARCELINO"
        cmbCity.AddItem "SAN NARCISO"
        cmbCity.AddItem "SANTA CRUZ"
        cmbCity.AddItem "SUBIC"
        cmbCity.AddItem "SUBIC BAY FREEPORT ZONE (METRO SUBIC)"
''Case "BATANES"
        ''cmbCity.AddItem "GOVERNOR-GENERAL JOSE VARGAS BASCO"
        ''cmbCity.AddItem "ITBAYAT"
        ''cmbCity.AddItem "IVANA"
        ''cmbCity.AddItem "MAHATAO"
        ''cmbCity.AddItem "SABTANG"
        ''cmbCity.AddItem "UYUGAN"
'' Case "CAGAYAN"
        ''cmbCity.AddItem "ABULUG"
        ''cmbCity.AddItem "ALCALA"
        ''cmbCity.AddItem "ALLACAPAN"
        ''cmbCity.AddItem "AMULUNG"
        ''cmbCity.AddItem "APARRI"
        ''cmbCity.AddItem "BAGGAO"
        ''cmbCity.AddItem "BALLESTEROS"
        ''cmbCity.AddItem "BUGUEY"
        ''cmbCity.AddItem "CALAYAN"
        ''cmbCity.AddItem "CAMALANIUGAN"
        ''cmbCity.AddItem "CLAVERIA"
        ''cmbCity.AddItem "ENRILE"
        ''cmbCity.AddItem "GATTARAN"
        ''cmbCity.AddItem "GONZAGA"
        ''cmbCity.AddItem "IGUIG"
        ''cmbCity.AddItem "LAL-LO"
        ''cmbCity.AddItem "LASAM"
        ''cmbCity.AddItem "PAMPLONA"
        ''cmbCity.AddItem "PEÑABLANCA"
        ''cmbCity.AddItem "PIAT"
        ''cmbCity.AddItem "RIZAL"
        ''cmbCity.AddItem "SANCHEZ-MIRA"
        ''cmbCity.AddItem "SANTA ANA"
        ''cmbCity.AddItem "SANTA PRAXEDES"
        ''cmbCity.AddItem "SANTA TERESITA"
        ''cmbCity.AddItem "SANTO NIÑO "
        ''cmbCity.AddItem "SOLANA"
        ''cmbCity.AddItem "TUAO"
        ''cmbCity.AddItem "TUGUEGARAO CITY"
   
   
       
End Select
txtpadd.Value = cmbCity.Value & " " + cmbProvince.Value & ", " + cmbRegion.Value
End Sub
 
Last edited by a moderator:

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
Put your lists of cities on a worksheet.
Name each of the lists of cities according to the name of the province (Formulas tab, Define name button). Now you can use this simple code:

VBA Code:
Private Sub cmbProvince_Change()
    With cmbCity
        .Clear
        .List = Range(cmbProvince.Value).Value
    End With
End Sub
 
Upvote 0
Put your lists of cities on a worksheet.
Name each of the lists of cities according to the name of the province (Formulas tab, Define name button). Now you can use this simple code:

VBA Code:
Private Sub cmbProvince_Change()
    With cmbCity
        .Clear
        .List = Range(cmbProvince.Value).Value
    End With
End Sub
Thank you sir jkpieterse. God Bless you..
 
Upvote 0

Forum statistics

Threads
1,223,894
Messages
6,175,254
Members
452,624
Latest member
gregg777

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top