ExcelBanter - VBA - Do not allow duplicates

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - VBA - Do not allow duplicates (https://www.excelbanter.com/excel-worksheet-functions/49358-vba-do-not-allow-duplicates.html)

TimE

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

Dave Peterson

Visit Chip Pearson's site for a Data|validation solution:
http://www.cpearson.com/excel/NoDupEntry.htm

TimE wrote:

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

--

Dave Peterson

All times are GMT +1. The time now is 01:16 AM.