View Single Post
  #1   Report Post  
TimE
 
Posts: n/a
Default VBA - Do not allow duplicates


I would like to prevent duplicates from being entered. If a duplicate
is entered (attempted), a message box will be displayed indicating the
row # of the original entry.

Cell A1 contains 1234

I try to enter 1234 in cell A223. I want a message box to appear
informing me of a duplicate at Row 1.

Thanks in advance for any assistance.

TimE.


--
TimE