Primary Key In Excel

  • November 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Primary Key In Excel as PDF for free.

More details

  • Words: 100
  • Pages: 1
open excel the press alt+f11 then dbclick on required sheet and paste the following code private sub worksheet_change(byval target as range) dim targ as range, cel as range, rg as range set targ = [d:d] 'change to the cell range being watched for duplicates set targ = intersect(targ, target) if targ is nothing then exit sub for each cel in targ.cells if cel <> "" then set rg = columns(cel.column).find(cel, lookin:=xlvalues, after:=cel) if rg.address <> cel.address then application.enableevents = false cel = "" cel.select application.enableevents = true msgbox "duplicate entry! " & cel.value end if end if next end sub

Related Documents

Primary Key In Excel
November 2019 23
3.primary Key
July 2020 5
Use Of Key Board In Excel
December 2019 26
Tefl In Primary Education
December 2019 24
Copd In Primary Care
June 2020 22