Problem while removing duplicate value using VBA

Hi Friends,

Request you kindly help me on the below issue. My excel contain 5 column like Name, Employee number, Age, mark, Grade. I need a VBA code to populate an error message when more than one row contains the same Name and emplyee number (only these 2 columns). I was not able to complete it. Requesting your help on this. Thanks.

You don't need VBA, just add a formula of

=IF(COUNTIFS($A:$A,$A2,$B:$B,B2)>1,"Duplicate,"")

and copy down.