TimE

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find and mark duplicates	maxtrixx	Excel Discussion (Misc queries)	3	May 6th 05 02:13 AM
Finding Duplicates	nospaminlich	Excel Worksheet Functions	4	February 5th 05 11:57 PM
Finding and Deleting duplicates in a column	Brian	Excel Worksheet Functions	3	February 5th 05 02:19 PM
removing duplicates testing in 2 coloms	Warzel	Excel Worksheet Functions	3	January 23rd 05 11:39 AM
Find duplicates	R. Choate	Excel Discussion (Misc queries)	5	November 28th 04 10:14 PM

All times are GMT +1. The time now is 08:17 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us