Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prohibit duplicate data in a cell
I need to prohibit the use of duplicate part numbers in a certain range of
cells. Using the worksheet_change event, I create an array of all existing part numbers. I can then go thru that array and compare it with the value of the cell that the user just typed a part number into. If I find that the part number that the user just typed in is a duplicate, I don't want to allow the focus to shift to another cell, and I want the cell value to be highlighted....similar to "data validation" where the data won't be accepted into the cell if it is invalid. I'm not sure how to do this part of the task. Can anyone point me in the right direction?? TIA. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA to delete Duplicate Records (1 column), before which, non-duplicate data merged into remaining row | Excel Programming | |||
Delete Duplicate data row wise from each cell | Excel Programming | |||
delete duplicate data in the same cell | Excel Programming | |||
Deleting duplicate data - inc original cell | Excel Programming | |||
Duplicate data in a cell... | Excel Worksheet Functions |