Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Warning of duplicates
If a user enters a number in column 'D' which has already been used, rather
than simply identifying that the number has been used already, how can I get a message box to appear asking if they want to continue using that particular number or not? If they select yes, end sub, if they select no, target.value = vbnullstring. It is purely a warning. In this case, dupes are allowed but I want to alert the user that the number they have entered has already been used therefore eliminating accidental dupes (hopefully). Can code inform the user that dupe(s) are on row xx? Thanks, -- Traa Dy Liooar Jock |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find duplicates, sum column then delete duplicates | Excel Programming | |||
Check for Duplicates then Sum cells of duplicates | Excel Programming | |||
Condensing a list with duplicates to a list with non-duplicates | Excel Worksheet Functions | |||
Duplicates in excel that aren't 100% DUPLICATES ... | Excel Discussion (Misc queries) | |||
Warning Box | Excel Programming |