VBA_Noob01
New Member
- Joined
- Oct 21, 2021
- Messages
- 1
- Office Version
- 2019
- 2016
- Platform
- Windows
Good day friends!
I would like some help on my problem. I have 2 workbooks (Workbook 1 is the data that needs to be highlighted, Workbook 2 is an Excel Add-in (.xlam) I made in which I inserted a Sheet that contains the source or the database.
I want to highlight the cell using VBA the Workbook 1, under table named "table1" and column "Offense", see attached:
by comparing it to source (Workbook 2) under table named "tb_source" column "Index_Crimes". See attached.
Hopefully someone can help me. Thank you.
I would like some help on my problem. I have 2 workbooks (Workbook 1 is the data that needs to be highlighted, Workbook 2 is an Excel Add-in (.xlam) I made in which I inserted a Sheet that contains the source or the database.
I want to highlight the cell using VBA the Workbook 1, under table named "table1" and column "Offense", see attached:
Workbook 1.xlsx | |||||
---|---|---|---|---|---|
M | N | O | |||
1 | STAGES OF FELONY | OFFENSE | OFFENSE CATEGORY | ||
2 | ABANDONING A MINOR - RPC Art. 276 | ||||
3 | ABANDONMENT OF MINOR BY PERSON ENTRUSTED WITH HIS CUSTODY; INDIFFERENCE OF PARENTS - RPC Art. 277 | ||||
4 | ABORTION PRACTICED BY A PHYSICIAN OR MIDWIFE AND DISPENSING OF ABORTIVES - RPC Art. 259 | ||||
5 | ACCESS DEVICES REGULATION ACT OF 1998 (CREDIT CARD VIOLATION ACT) - RA 8484 as amended by RA 11449 | ||||
6 | ACTS OF LASCIVIOUSNESS - RPC Art. 336 | ||||
7 | ACTS OF LASCIVIOUSNESS WITH THE CONSENT OF THE OFFENDED PARTY - RPC Art 339 | ||||
8 | ADULTERY - RPC Art. 333 | ||||
9 | ALARMS AND SCANDALS - RPC Art. 155 | ||||
10 | AN ACT DEFINING AND PENALIZING CERTAIN PROHIBITED ACTS INIMICAL TO THE PUBLIC INTERESTS AND NATIONAL SECURITY INVOLVING PETROLEUM AND/OR PETROLEUM PRODUCTS, PRESCRIBING PENALTIES THEREFOR AND FOR OTHER PURPOSES`, BY INCLUDING SHORT-SELLING AND ADULTE - PD 1865 | ||||
11 | AN ACT INCREASING THE PENALTIES FOR ILLEGAL NUMBERS GAMES, AMENDING CERTAIN PROVISIONS OF PRESIDENTIAL DECREE NO. 1602, AND FOR OTHER PURPOSES - RA 9287 amending pd 1602 | ||||
12 | AN ACT REGULATING THE SALE, MANUFACTURE, DISTRIBUTION AND USE OF FIRECRACKERS AND OTHER PYROTECHNIC DEVICES - RA 7183 | ||||
13 | ANIMAL WELFARE ACT OF 1998 - RA 8485 | ||||
14 | ANTI-BULLYING ACT OF 2013 - RA 10627 | ||||
15 | ANTI-CABLE TELEVISION AND CABLE INTERNET TAPPING ACT OF 2013 - RA 10515 | ||||
16 | ANTI-CATTLE RUSTLING LAW OF 1974 - PD 533 | ||||
17 | ANTI-CHILD PORNOGRAPHY ACT OF 2009 - RA 9775 | ||||
18 | ANTI-DRUNK AND DRUGGED DRIVING ACT OF 2013 - RA 10586 | ||||
19 | ANTI-ELECTRICITY AND ELECTRIC TRANSMISSION LINES/MATERIALS PILFERAGE ACT OF 1994 - RA 7832 | ||||
20 | ANTI-FENCING LAW 0F 1979 - RA 1612 | ||||
21 | ANTI-FENCING LAW OF 1979 - PD 1612 | ||||
22 | ANTI-GAMBLING LAW - PD 1602 | ||||
23 | ANTI-GRAFT AND CORRUPT PRACTICES ACT - RA 3019 as amended by BP Blg 195 | ||||
24 | ANTI-HAZING LAW - RA 8049 | ||||
25 | ANTI-HIGHWAY ROBBERY LAW OF 1974 - PD 532 | ||||
26 | ANTI-PHOTO AND VIDEO VOYEURISM ACT OF 2009 - RA 9995 | ||||
27 | ANTI-RABIES ACT OF 2007 - RA 9482 | ||||
28 | ANTI-RAPE LAW OF 1997 - RA 8353 | RAPE | |||
29 | ANTI-RAPE LAW OF 1997 - RA 8353 | RAPE | |||
30 | ANTI-RAPE LAW OF 1997 - RA 8353 | RAPE | |||
31 | ANTI-RAPE LAW OF 1997 - RA 8353 | RAPE | |||
32 | ANTI-RAPE LAW OF 1997 - RA 8353 | RAPE | |||
33 | ANTI-RAPE LAW OF 1997 - RA 8353 | RAPE | |||
34 | ANTI-RED TAPE ACT OF 2007 - RA 9485 | ||||
35 | ANTI-TRAFFICKING IN PERSONS ACT OF 2003 - RA 9208 as amended by RA 10364 (Expanded ATIP) | ||||
36 | ANTI-VIOLENCE AGAINST WOMEN AND THEIR CHILDREN ACT OF 2004 - RA 9262 | ||||
37 | ARSON OF PROPERTY OF SMALL VALUE - RPC Art. 323 | ||||
38 | BAYANIHAN HEAL AS ONE ACT - RA 11469 | ||||
39 | BIGAMY - RPC Art. 349 | ||||
40 | BOUNCING CHECK LAW - BP 22 | ||||
41 | BURNING ONE'S OWN PROPERTY AS MEANS TO COMMIT ARSON - RPC Art. 325 | ||||
42 | CHAIN SAW ACT OF 2002 - RA 9175 | ||||
43 | CHALLENGING TO A DUEL - RPC Art. 261 | ||||
44 | ****FIGHTING LAW OF 1974 - PD 449 | ||||
45 | COCONUT PRESERVATION ACT OF 1995 - RA 8048 as amended by RA 10593 | ||||
46 | CODE OF CONDUCT AND ETHICAL STANDARDS FOR PUBLIC OFFICIALS AND EMPLOYEES - RA 6713 | ||||
47 | CODE ON SANITATION OF THE PHILIPPINES - PD 856 | ||||
48 | COMPREHENSIVE DANGEROUS DRUGS ACT OF 2002 - RA 9165 | ||||
49 | COMPREHENSIVE DANGEROUS DRUGS ACT OF 2002 - CULTIVATION OR CULTURE OF PLANTS CLASSIFIED AS DANGEROUS DRUGS OR ARE SOURCES THEREOF - RA 9165 Article II Section 16 para 1 | ||||
50 | COMPREHENSIVE DANGEROUS DRUGS ACT OF 2002 - IMPORTATION OF DANGEROUS DRUGS - RA 9165 Article II Section 4 para 1 | ||||
51 | COMPREHENSIVE DANGEROUS DRUGS ACT OF 2002 - POSSESSION OF DANGEROUS DRUGS - RA 9165 Article II Section 11 | ||||
52 | COMPREHENSIVE DANGEROUS DRUGS ACT OF 2002 - POSSESSION OF DANGEROUS DRUGS DURING PARTIES, SOCIAL GATHERINGS OR MEETINGS - RA 9165 Article II Section 13 | ||||
53 | COMPREHENSIVE DANGEROUS DRUGS ACT OF 2002 - POSSESSION OF EQUIPMENT, INSTRUMENT, APPARATUS AND OTHER PARAPHERNALIA FOR DANGEROUS DRUGS - RA 9165 Article II Section 12 | ||||
54 | COMPREHENSIVE DANGEROUS DRUGS ACT OF 2002 - SALE, TRADING, ADMINISTRATION, DISPENSATION, DELIVERY, DISTRIBUTION AND TRANSPORTATION OF DANGEROUS DRUGS - RA 9165 Article II Section 5 para 1 | ||||
55 | COMPREHENSIVE DANGEROUS DRUGS ACT OF 2002 - USE OF DANGEROUS DRUGS - RA 9165 Article II Section 15 | ||||
56 | COMPREHENSIVE LAW ON FIREARMS AND AMMUNITION - RA 10591 (covers RA 9516, RA 8294 and PD 1866) | ||||
57 | CUSTOMS MODERNIZATION AND TARIFF ACT (CMTA) - RA 10863 | ||||
58 | CYBERCRIME PREVENTION ACT OF 2012 - RA 10175 | ||||
59 | DAMAGE AND OBSTRUCTION TO MEANS OF COMMUNICATION - RPC Art. 330 | ||||
60 | DATA PRIVACY ACT OF 2012 - RA 10173 | ||||
61 | EXPANDED ANTI-TRAFFICKING IN PERSONS ACT OF 2012 - RA 10364 | ||||
62 | FOOD AND DRUG ADMINISTRATION ACT OF 2009 - RA 9711 | ||||
63 | FURTHER AMENDING ARTICLES 38 AND 39 OF THE LABOR CODE BY MAKING ILLEGAL RECRUITMENT A CRIME OF ECONOMIC SABOTAGE AND PUNISHABLE WITH LIFE IMPRISONMENT. - PD 2018 | ||||
64 | HOMICIDE - RPC Art. 249 | HOMICIDE | |||
65 | HOMICIDE - RPC Art. 249 | HOMICIDE | |||
66 | ILLEGAL COMMERCIAL IMPORTATION OF USED CLOTHING AND RAGS - RA 4653 | ||||
67 | ILLEGAL FISHING / THE PHILIPPINE FISHERIES CODE OF 1998 - RA 8550 as amended by RA 10654 | ||||
68 | ILLEGAL POSSESSION OF BLADED, POINTED OR BLUNT WEAPONS - BP 6 | ||||
69 | ILLEGAL POSSESSION, MANUFACTURE, ACQUISITION, OF FIREARMS, AMMUNITION OR EXPLOSIVES - PD 1866 as amended by RA 8294 and RA 9516 | ||||
70 | JUVENILE JUSTICE AND WELFARE ACT OF 2006 - RA 9344 | ||||
71 | LAND TRANSPORTATION AND TRAFFIC CODE (COMPULSARY REGISTRATION OF MOTOR VEHICLES) - RPC Art. 4136 as amended by BP Blg 74 | ||||
72 | LESS SERIOUS PHYSICAL INJURIES - RPC Art. 265 | PHYSICAL INJURIES | |||
73 | LESS SERIOUS PHYSICAL INJURIES - RPC Art. 265 | PHYSICAL INJURIES | |||
74 | LESS SERIOUS PHYSICAL INJURIES - RPC Art. 265 | PHYSICAL INJURIES | |||
75 | MALICIOUS DISSEMINATION OF FALSE INFORMATION OF THE WILLFUL MAKING OF ANY THREAT CONCERNING BOMBS, EXPLOSIVES OR ANY SIMILAR DEVICE OR MEANS OF DESTRUCTION AND IMPOSING PENALTIES THEREFOR. - PD 1727 | ||||
76 | MANDATORY REPORTING OF NOTIFIABLE DISEASES AND HEALTH EVENTS OF PUBLIC HEALTH CONCERN ACT - RA 11332 | ||||
77 | MOTORCYCLE HELMET ACT OF 2009 - RA 10054 | ||||
78 | MURDER - RPC Art. 248 | MURDER | |||
79 | MURDER - RPC Art. 248 | MURDER | |||
80 | OMNIBUS ELECTION CODE OF THE PHILIPPINES - BP 881 | ||||
81 | PARRICIDE - RPC Art. 246 | MURDER | |||
82 | PENALIZING OBSTRUCTION OF APPREHENSION AND PROSECUTION OF CRIMINAL OFFENDERS. - PD 1829 | ||||
83 | PENALIZING THE UNAUTHORIZED INSTALLATION OF WATER, ELECTRICAL OR TELEPHONE CONNECTIONS, THE USE OF TAMPERED WATER OR ELECTRICAL METERS, AND OTHER ACTS - PD 401 | ||||
84 | PENALIZING THE USE OR POSSESSION OR THE UNAUTHORIZED SALE TO MINORS OF VOLATILE SUBSTANCES FOR THE PURPOSE OF INDUCING INTOXICATION OR IN ANY MANNER CHANGING, DISTORTING OR DISTURBING THE AUDITORY, VISUAL OR MENTAL PROCESS - PD 1619 | ||||
85 | PEOPLE'S SMALL-SCALE MINING ACT OF 1991 - RA 7076 | ||||
86 | PHILIPPINE FISHERIES CODE - RA 10654 | ||||
87 | PHILIPPINE MINING ACT OF 1995 - RA 7942 | ||||
88 | PHILIPPINE PASSPORT ACT OF 1996 - RA 8239 | ||||
89 | PRICE ACT - RA 7581 | ||||
90 | PROVIDING FOR THE ESTABLISHMENT OF SMOKE-FREE ENVIRONMENTS IN PUBLIC AND ENCLOSED PLACES - EO 26 in relation to RA 8749 and RA 9211 | ||||
91 | QUARANTINE ACT OF 2004 - RA 9271 | ||||
92 | RAPE - RPC Art 266-A | RAPE | |||
93 | RAPE - RPC Art 266-A | RAPE | |||
94 | REVISED FORESTRY CODE OF THE PHILIPPINES - PD 705 | ||||
95 | SAFE SPACES ACT (GENDER BASED SEXUAL HARASSMENT) - RA 11313 | ||||
96 | SEXUAL HARRASSMENT ACT OF 1995 - RA 7877 | ||||
97 | SLIGHT PHYSICAL INJURIES AND MALTREATMENT - RPC Art. 266 | PHYSICAL INJURIES | |||
98 | SPECIAL PROTECTION OF CHILDREN AGAINST CHILD ABUSE, EXPLOITATION AND DISCRIMINATION ACT. (ANTI- CHILD ABUSE LAW) - RA 7610 | ||||
99 | TARIFF AND CUSTOMS LAWS (ANTI-SMUGGLING) - PD 1464 | ||||
100 | THE ANTI-SQUATTING LAW REPEAL ACT OF 1997 - RA 8368 | ||||
101 | THE CONSUMER ACT OF THE PHILIPPINES - RA 7394 | ||||
102 | THE FORESTRY REFORM CODE OF THE PHILIPPINES (ILLEGAL LOGGING) - PD 705 | ||||
103 | THE HUMAN SECURITY ACT OF 2007 - RA 9372 | ||||
104 | THE INTELLECTUAL PROPERTY CODE OF THE PHILIPPINES (THE COPYRIGHT LAW). - RA 8293 | ||||
105 | THE MEAT INSPECTION CODE OF THE PHILIPPINES - RA 9296 | ||||
106 | THE PHILIPPINE DENTAL ACT OF 2007 - RA 9484 | ||||
107 | THE SECURITIES REGULATION CODE - RA 8799 | ||||
108 | THEFT - RPC Art. 308 | THEFT | |||
109 | THEFT - RPC Art. 308 | THEFT | |||
110 | THEFT - RPC Art. 308 | THEFT | |||
111 | TOBACCO REGULATION ACT OF 2003 - RA 9211 | ||||
112 | URBAN DEVELOPMENT AND HOUSING ACT OF 1992 - RA 7279 | ||||
113 | VIOLATION OF MAGNA CARTA FOR DISABLED PERSON - RA 7277 AS AMENDED BY ra 9442 | ||||
114 | WILDLIFE RESOURCES CONSERVATION AND PROTECTION ACT - RA 9147 | ||||
Detailed_Report |
by comparing it to source (Workbook 2) under table named "tb_source" column "Index_Crimes". See attached.
Source.xlsm | ||||||
---|---|---|---|---|---|---|
B | C | D | E | |||
4 | Index_Crimes | other_nic | spl_nic | rir | ||
5 | ANTI-RAPE LAW OF 1997 - RA 8353 | ABANDONING A MINOR - RPC Art. 276 | ACCESS DEVICES REGULATION ACT OF 1998 (CREDIT CARD VIOLATION ACT) - RA 8484 as amended by RA 11449 | IMPRUDENCE AND NEGLIGENCE (RECKLESS IMPRUDENCE) - RPC Art. 365 | ||
6 | ARSON WITH HOMICIDE - RPC Art. 320 amended by PD 1613 and PD 1744 | ABANDONMENT OF MINOR BY PERSON ENTRUSTED WITH HIS CUSTODY; INDIFFERENCE OF PARENTS - RPC Art. 277 | AN ACT DEFINING AND PENALIZING CERTAIN PROHIBITED ACTS INIMICAL TO THE PUBLIC INTERESTS AND NATIONAL SECURITY INVOLVING PETROLEUM AND/OR PETROLEUM PRODUCTS, PRESCRIBING PENALTIES THEREFOR AND FOR OTHER PURPOSES`, BY INCLUDING SHORT-SELLING AND ADULTE - PD 1865 | RECKLESS IMPRUDENCE RESULTING TO DAMAGE TO PROPERTY - RPC Art 365 | ||
7 | HOMICIDE - RPC Art. 249 | ABORTION PRACTICED BY A PHYSICIAN OR MIDWIFE AND DISPENSING OF ABORTIVES - RPC Art. 259 | AN ACT INCREASING THE PENALTIES FOR ILLEGAL NUMBERS GAMES, AMENDING CERTAIN PROVISIONS OF PRESIDENTIAL DECREE NO. 1602, AND FOR OTHER PURPOSES - RA 9287 amending pd 1602 | RECKLESS IMPRUDENCE RESULTING TO HOMICIDE - RPC Art 365 | ||
8 | INFANTICIDE - RPC Art. 255 | ACTS OF LASCIVIOUSNESS - RPC Art. 336 | AN ACT REGULATING THE SALE, MANUFACTURE, DISTRIBUTION AND USE OF FIRECRACKERS AND OTHER PYROTECHNIC DEVICES - RA 7183 | RECKLESS IMPRUDENCE RESULTING TO MULTIPLE DAMAGE TO PROPERTY - RPC Art 365 | ||
9 | LESS SERIOUS PHYSICAL INJURIES - RPC Art. 265 | ACTS OF LASCIVIOUSNESS WITH THE CONSENT OF THE OFFENDED PARTY - RPC Art 339 | ANIMAL WELFARE ACT OF 1998 - RA 8485 | RECKLESS IMPRUDENCE RESULTING TO MULTIPLE HOMICIDE - RPC Art 365 | ||
10 | MURDER - RPC Art. 248 | ADULTERY - RPC Art. 333 | ANTI-CABLE TELEVISION AND CABLE INTERNET TAPPING ACT OF 2013 - RA 10515 | RECKLESS IMPRUDENCE RESULTING TO MULTIPLE PHYSICAL INJURY - RPC Art 365 | ||
11 | NEW ANTI-CARNAPPING ACT OF 2016 - MC - RA 10883 (repealed RA 6539) | ALARMS AND SCANDALS - RPC Art. 155 | ANTI-CATTLE RUSTLING LAW OF 1974 - PD 533 | RECKLESS IMPRUDENCE RESULTING TO PHYSICAL INJURY - RPC Art 365 | ||
12 | NEW ANTI-CARNAPPING ACT OF 2016 - MV - RA 10883 (repealed RA 6539) | ARSON OF PROPERTY OF SMALL VALUE - RPC Art. 323 | ANTI-CHILD PORNOGRAPHY ACT OF 2009 - RA 9775 | |||
13 | NEW ANTI-CARNAPPING ACT OF 2016 - OWNER, DRIVER OR OCCUPANT VEHICLE IS KILLED OR RAPED - MC - RA 10883 (repealed RA 6539) | BIGAMY - RPC Art. 349 | ANTI-DRUNK AND DRUGGED DRIVING ACT OF 2013 - RA 10586 | |||
14 | NEW ANTI-CARNAPPING ACT OF 2016 - OWNER, DRIVER OR OCCUPANT VEHICLE IS KILLED OR RAPED - MV - RA 10883 (repealed RA 6539) | BURNING ONE'S OWN PROPERTY AS MEANS TO COMMIT ARSON - RPC Art. 325 | ANTI-ELECTRICITY AND ELECTRIC TRANSMISSION LINES/MATERIALS PILFERAGE ACT OF 1994 - RA 7832 | |||
15 | PARRICIDE - RPC Art. 246 | CHALLENGING TO A DUEL - RPC Art. 261 | ANTI-FENCING LAW 0F 1979 - RA 1612 | |||
16 | QUALIFIED RAPE - RPC Art 266-B | CONCUBINAGE - RPC Art. 334 | ANTI-FENCING LAW OF 1979 - PD 1612 | |||
17 | QUALIFIED THEFT - RPC Art. 310 as amended by BP Blg 71 | CONSENTED ABDUCTION - RPC Art. 343 | ANTI-GAMBLING LAW - PD 1602 | |||
18 | RAPE - RPC Art 266-A | CORRUPTION OF PUBLIC OFFICIALS - RPC Art. 212 | ANTI-GRAFT AND CORRUPT PRACTICES ACT - RA 3019 as amended by BP Blg 195 | |||
19 | RAPE WITH HOMICIDE - RPC Art. 266-B | COUNTERFEITING THE GREAT SEAL OF THE GOVERNMENT OF THE PHILIPPINE ISLANDS, FORGING THE SIGNATURE OR STAMP OF THE CHIEF EXECUTIVE - RPC Art. 161 | ANTI-HAZING LAW - RA 8049 | |||
20 | ROBBERY - RPC Art. 293 | CRIMES INVOLVING DESTRUCTION - RPC Art. 324 | ANTI-HIGHWAY ROBBERY LAW OF 1974 - PD 532 | |||
21 | ROBBERY IN AN INHABITED HOUSE OR PUBLIC BUILDING OR EDIFICE DEVOTED TO WORSHIP - RPC Art. 299 | DELIVERY OF PRISONERS FROM JAILS - RPC Art. 156 | ANTI-PHOTO AND VIDEO VOYEURISM ACT OF 2009 - RA 9995 | |||
22 | ROBBERY IN AN UNINHABITED PLACE AND BY A BAND - RPC Art. 300 | DESTRUCTIVE ARSON - RPC Art. 320 amended by PD 1613 and PD 1744 | ANTI-RABIES ACT OF 2007 - RA 9482 | |||
23 | ROBBERY IN AN UNINHABITED PLACE OR IN A PRIVATE BUILDING - RPC Art. 302 | DIRECT ASSAULTS - RPC Art. 148 | ANTI-RED TAPE ACT OF 2007 - RA 9485 | |||
24 | ROBBERY WITH HOMICIDE - RPC Art. 294 | DIRECT BRIBERY - RPC Art. 210 | ANTI-TRAFFICKING IN PERSONS ACT OF 2003 - RA 9208 as amended by RA 10364 (Expanded ATIP) | |||
25 | ROBBERY WITH SERIOUS PHYSICAL INJURIES - RPC Art. 294 | DISCHARGE OF FIREARMS - RPC Art 254 | ANTI-VIOLENCE AGAINST WOMEN AND THEIR CHILDREN ACT OF 2004 - RA 9262 | |||
26 | ROBBERY WITH VIOLENCE AGAINST OR INTIMIDATION OF PERSONS - RPC Art. 294 | DISTURBANCE OF PROCEEDINGS - RPC Art. 144 | BAYANIHAN HEAL AS ONE ACT - RA 11469 | |||
27 | SERIOUS PHYSICAL INJURIES - RPC Art. 263 | ESCAPE OF PRISONER UNDER THE CUSTODY OF A PERSON NOT A PUBLIC - RPC Art. 225 | BOUNCING CHECK LAW - BP 22 | |||
28 | SLIGHT PHYSICAL INJURIES AND MALTREATMENT - RPC Art. 266 | EVASION THROUGH NEGLIGENCE - RPC Art. 224 | CHAIN SAW ACT OF 2002 - RA 9175 | |||
29 | THEFT - RPC Art. 308 | EXECUTION OF DEEDS BY MEANS OF VIOLENCE OR INTIMIDATION - RPC Art. 298 | ****FIGHTING LAW OF 1974 - PD 449 | |||
30 | EXPLOITATION OF CHILD LABOR - RPC Art. 273 | COCONUT PRESERVATION ACT OF 1995 - RA 8048 as amended by RA 10593 | ||||
31 | FALSE TESTIMONY IN OTHER CASES AND PERJURY IN SOLEMN AFFIRMATION - RPC Art. 183 | CODE OF CONDUCT AND ETHICAL STANDARDS FOR PUBLIC OFFICIALS AND EMPLOYEES - RA 6713 | ||||
32 | FALSIFICATION BY PRIVATE INDIVIDUAL AND USE OF FALSIFIED DOCUMENTS - RPC Art. 172 | CODE ON SANITATION OF THE PHILIPPINES - PD 856 | ||||
33 | FORCIBLE ABDUCTION - RPC Art. 342 | COMPREHENSIVE DANGEROUS DRUGS ACT OF 2002 - RA 9165 | ||||
34 | GRAVE COERCIONS - RPC Art. 286 amended by 3815 and RA 7890 | COMPREHENSIVE DANGEROUS DRUGS ACT OF 2002 - CULTIVATION OR CULTURE OF PLANTS CLASSIFIED AS DANGEROUS DRUGS OR ARE SOURCES THEREOF - RA 9165 Article II Section 16 para 1 | ||||
35 | GRAVE SCANDAL - RPC Art. 200 | COMPREHENSIVE DANGEROUS DRUGS ACT OF 2002 - IMPORTATION OF DANGEROUS DRUGS - RA 9165 Article II Section 4 para 1 | ||||
36 | GRAVE THREATS - RPC Art. 282 | COMPREHENSIVE DANGEROUS DRUGS ACT OF 2002 - POSSESSION OF DANGEROUS DRUGS - RA 9165 Article II Section 11 | ||||
37 | HIGHGRADING OR THEFT OF GOLD FROM A MINING CLAIM OR MINING CAMP (PRESCRIBING A HEAVIER MINIMUM PENALTY FOR) - PD 581 | COMPREHENSIVE DANGEROUS DRUGS ACT OF 2002 - POSSESSION OF DANGEROUS DRUGS DURING PARTIES, SOCIAL GATHERINGS OR MEETINGS - RA 9165 Article II Section 13 | ||||
38 | ILLEGAL POSSESSION AND USE OF FALSE TREASURY OR BANK NOTES AND OTHER INSTRUMENTS OF CREDIT - RPC Art. 168 | COMPREHENSIVE DANGEROUS DRUGS ACT OF 2002 - POSSESSION OF EQUIPMENT, INSTRUMENT, APPARATUS AND OTHER PARAPHERNALIA FOR DANGEROUS DRUGS - RA 9165 Article II Section 12 | ||||
39 | ILLEGAL USE OF UNIFORMS OR INSIGNIA - RPC Art. 179 | COMPREHENSIVE DANGEROUS DRUGS ACT OF 2002 - SALE, TRADING, ADMINISTRATION, DISPENSATION, DELIVERY, DISTRIBUTION AND TRANSPORTATION OF DANGEROUS DRUGS - RA 9165 Article II Section 5 para 1 | ||||
40 | INDIRECT ASSAULTS - RPC Art. 149 | COMPREHENSIVE DANGEROUS DRUGS ACT OF 2002 - USE OF DANGEROUS DRUGS - RA 9165 Article II Section 15 | ||||
41 | INDUCING A MINOR TO ABANDON HIS HOME - RPC Art. 271 | COMPREHENSIVE LAW ON FIREARMS AND AMMUNITION - RA 10591 (covers RA 9516, RA 8294 and PD 1866) | ||||
42 | INTENTIONAL ABORTION - RPC Art. 256 | CUSTOMS MODERNIZATION AND TARIFF ACT (CMTA) - RA 10863 | ||||
43 | INTRIGUING AGAINST HONOR - RPC Art. 364 | CYBERCRIME PREVENTION ACT OF 2012 - RA 10175 | ||||
44 | KIDNAP FOR RANSOM - RPC Art. 267 as amended by RA 18 and RA 1084 | DAMAGE AND OBSTRUCTION TO MEANS OF COMMUNICATION - RPC Art. 330 | ||||
45 | KIDNAPPING AND FAILURE TO RETURN A MINOR - RPC Art. 270 | DATA PRIVACY ACT OF 2012 - RA 10173 | ||||
46 | KIDNAPPING AND SERIOUS ILLEGAL DETENTION - RPC Art. 267 as amended by RA 18 and RA 1084 | FOOD AND DRUG ADMINISTRATION ACT OF 2009 - RA 9711 | ||||
47 | LIBEL - RPC Art. 353 | FURTHER AMENDING ARTICLES 38 AND 39 OF THE LABOR CODE BY MAKING ILLEGAL RECRUITMENT A CRIME OF ECONOMIC SABOTAGE AND PUNISHABLE WITH LIFE IMPRISONMENT. - PD 2018 | ||||
48 | LIBEL MEANS BY WRITINGS OR SIMILAR MEANS - RPC Art. 355 | ILLEGAL COMMERCIAL IMPORTATION OF USED CLOTHING AND RAGS - RA 4653 | ||||
49 | LIGHT COERCIONS - RPC Art. 287 | ILLEGAL FISHING / THE PHILIPPINE FISHERIES CODE OF 1998 - RA 8550 as amended by RA 10654 | ||||
50 | LIGHT THREATS - RPC Art. 283 | ILLEGAL POSSESSION OF BLADED, POINTED OR BLUNT WEAPONS - BP 6 | ||||
51 | MALICIOUS MISCHIEF - RPC Art. 327 | ILLEGAL POSSESSION, MANUFACTURE, ACQUISITION, OF FIREARMS, AMMUNITION OR EXPLOSIVES - PD 1866 as amended by RA 8294 and RA 9516 | ||||
52 | MALVERSATION OF PUBLIC FUNDS OR PROPERTY; PRESUMPTION OF MALVERSATION. - RPC Art. 217 | LAND TRANSPORTATION AND TRAFFIC CODE (COMPULSARY REGISTRATION OF MOTOR VEHICLES) - RPC Art. 4136 as amended by BP Blg 74 | ||||
53 | OCCUPATION OF REAL PROPERTY OR USURPATION OF REAL RIGHTS IN PROPERTY - RPC Art. 312 | MALICIOUS DISSEMINATION OF FALSE INFORMATION OF THE WILLFUL MAKING OF ANY THREAT CONCERNING BOMBS, EXPLOSIVES OR ANY SIMILAR DEVICE OR MEANS OF DESTRUCTION AND IMPOSING PENALTIES THEREFOR. - PD 1727 | ||||
54 | OTHER DECEITS - RPC Art. 318 | MANDATORY REPORTING OF NOTIFIABLE DISEASES AND HEALTH EVENTS OF PUBLIC HEALTH CONCERN ACT - RA 11332 | ||||
55 | OTHER FORMS OF ARSON - RPC Art. 321 | MOTORCYCLE HELMET ACT OF 2009 - RA 10054 | ||||
56 | OTHER FORMS OF SWINDLING - RPC Art. 316 as amended by PD 1689 | OMNIBUS ELECTION CODE OF THE PHILIPPINES - BP 881 | ||||
57 | OTHER FORMS OF TRESPASS - RPC Art. 281 | PENALIZING OBSTRUCTION OF APPREHENSION AND PROSECUTION OF CRIMINAL OFFENDERS. - PD 1829 | ||||
58 | OTHER FRAUDS - RPC Art. 214 | PENALIZING THE USE OR POSSESSION OR THE UNAUTHORIZED SALE TO MINORS OF VOLATILE SUBSTANCES FOR THE PURPOSE OF INDUCING INTOXICATION OR IN ANY MANNER CHANGING, DISTORTING OR DISTURBING THE AUDITORY, VISUAL OR MENTAL PROCESS - PD 1619 | ||||
59 | OTHER LIGHT THREATS - RPC Art. 285 | PEOPLE'S SMALL-SCALE MINING ACT OF 1991 - RA 7076 | ||||
60 | OTHER SIMILAR COERCIONS - RPC Art. 288 | PHILIPPINE FISHERIES CODE - RA 10654 | ||||
61 | POSSESSION OF PICKLOCKS OR SIMILAR TOOLS - RPC Art. 304 | PHILIPPINE MINING ACT OF 1995 - RA 7942 | ||||
62 | QUALIFIED SEDUCTION - RPC Art. 337 | PHILIPPINE PASSPORT ACT OF 1996 - RA 8239 | ||||
63 | QUALIFIED SEXUAL ASSAULT - RPC Art 266-B | PRICE ACT - RA 7581 | ||||
64 | QUALIFIED TRESPASS TO DWELLING - RPC Art. 280 | PROVIDING FOR THE ESTABLISHMENT OF SMOKE-FREE ENVIRONMENTS IN PUBLIC AND ENCLOSED PLACES - EO 26 in relation to RA 8749 and RA 9211 | ||||
65 | REBELLION OR INSURRECTION - RPC Art. 134 | QUARANTINE ACT OF 2004 - RA 9271 | ||||
66 | RESISTANCE AND DISOBEDIENCE TO A PERSON IN AUTHORITY OR THE AGENTS OF SUCH PERSON - RPC Art. 151 | REVISED FORESTRY CODE OF THE PHILIPPINES - PD 705 | ||||
67 | SEARCHING DOMICILE WITHOUT WITNESSES - RPC Art. 130 | SAFE SPACES ACT (GENDER BASED SEXUAL HARASSMENT) - RA 11313 | ||||
68 | SEXUAL ASSAULT - RPC Art 266-A | SEXUAL HARRASSMENT ACT OF 1995 - RA 7877 | ||||
69 | SIMPLE SEDUCTION - RPC Art. 338 | SPECIAL PROTECTION OF CHILDREN AGAINST CHILD ABUSE, EXPLOITATION AND DISCRIMINATION ACT. (ANTI- CHILD ABUSE LAW) - RA 7610 | ||||
70 | SLANDER (ORAL DEFAMATION) - RPC Art. 358 | TARIFF AND CUSTOMS LAWS (ANTI-SMUGGLING) - PD 1464 | ||||
71 | SLANDER BY DEED - RPC Art. 359 | THE CONSUMER ACT OF THE PHILIPPINES - RA 7394 | ||||
72 | SLIGHT ILLEGAL DETENTION - RPC Art. 268 | THE FORESTRY REFORM CODE OF THE PHILIPPINES (ILLEGAL LOGGING) - PD 705 | ||||
73 | SPECIAL CASES OF MALICIOUS MISCHIEF - RPC Art. 329 | THE HUMAN SECURITY ACT OF 2007 - RA 9372 | ||||
74 | SWINDLING (ESTAFA) - RPC Art. 315 as amended by PD 1689 | THE INTELLECTUAL PROPERTY CODE OF THE PHILIPPINES (THE COPYRIGHT LAW). - RA 8293 | ||||
75 | SWINDLING A MINOR - RPC Art. 317 | THE MEAT INSPECTION CODE OF THE PHILIPPINES - RA 9296 | ||||
76 | TUMULTS AND OTHER DISTURBANCE OF PUBLIC ORDERS; TUMULTUOUS DISTURBANCE OR INTERRUPTION LIABLE TO CAUSE DISTURBANCE - RPC Art. 153 | THE PHILIPPINE DENTAL ACT OF 2007 - RA 9484 | ||||
77 | UNINTENTIONAL ABORTION - RPC Art. 257 | THE SECURITIES REGULATION CODE - RA 8799 | ||||
78 | UNJUST VEXATIONS - RPC Art. 287 | TOBACCO REGULATION ACT OF 2003 - RA 9211 | ||||
79 | UNLAWFUL ARREST - RPC Art. 269 | VIOLATION OF MAGNA CARTA FOR DISABLED PERSON - RA 7277 AS AMENDED BY ra 9442 | ||||
80 | USING FICTITIOUS NAME AND CONCEALING TRUE NAME - RPC Art. 178 | WILDLIFE RESOURCES CONSERVATION AND PROTECTION ACT - RA 9147 | ||||
81 | USURPATION OF AUTHORITY OR OFFICIAL FUNCTIONS - RPC Art. 177 | THE ANTI-SQUATTING LAW REPEAL ACT OF 1997 - RA 8368 | ||||
82 | VIOLATION OF DOMICILE - RPC Art. 128 | URBAN DEVELOPMENT AND HOUSING ACT OF 1992 - RA 7279 | ||||
83 | IMMORAL DOCTRINES, OBSCENE PUBLICATIONS AND EXHIBITIONS AND INDECENT SHOWS - RPC Art. 201 as amended by PD 960 and PD 969 | PENALIZING THE UNAUTHORIZED INSTALLATION OF WATER, ELECTRICAL OR TELEPHONE CONNECTIONS, THE USE OF TAMPERED WATER OR ELECTRICAL METERS, AND OTHER ACTS - PD 401 | ||||
84 | ANTI-MONEY LAUNDERING ACT OF 2001 - RA 9160 as amended by RA 9194 and RA 10365 | ANTI-BULLYING ACT OF 2013 - RA 10627 | ||||
85 | CONNIVING WITH OR CONSENTING TO EVASION - RPC Art. 223 | JUVENILE JUSTICE AND WELFARE ACT OF 2006 - RA 9344 | ||||
86 | COUNTERFEITING, IMPORTING AND UTTERING INSTRUMENTS NOT PAYABLE TO BEARER - RPC Art. 167 | EXPANDED ANTI-TRAFFICKING IN PERSONS ACT OF 2012 - RA 10364 | ||||
87 | ABANDONMENT OF PERSON IN DANGER AND ABANDONMENT OF ONE'S OWN VICTIM - RPC Art. 275 | |||||
88 | MALICIOUS DELAY IN THE ADMINISTRATION OF JUSTICE - RPC Art. 207 | |||||
89 | ADMINISTERING INJURIOUS SUBSTANCES OR BEVERAGES - RPC Art. 264 | |||||
90 | MALTREATMENT OF PRISONERS - RPC Art. 235 | |||||
91 | INCRIMINATING INNOCENT PERSON - RPC Art. 363 | |||||
92 | EVASION OF SERVICE OF SENTENCE - RPC Art. 157 | |||||
93 | INCITING TO WAR OR GIVING MOTIVES FOR REPRISALS - RPC Art. 118 | |||||
94 | USING FORGED SIGNATURE OR COUNTERFEIT SEAL OR STAMP - RPC Art. 162 | |||||
95 | ATTEMPTED AND FRUSTRATED ROBBERY COMMITTED UNDER CERTAIN CIRCUMSTANCES (HOMICIDE COMMITTED) - RPC Art. 297 | |||||
96 | ARBITRARY DETENTION - RPC Art. 124 | |||||
97 | ABUSES AGAINST CHASTITY; PENALTIES - RPC Art. 245 | |||||
98 | ALTERING BOUNDARIES OR LANDMARKS - RPC Art. 313 | |||||
99 | VAGRANTS AND PROSTITUTES - RPC Art 202 | |||||
Source |
Hopefully someone can help me. Thank you.