duplicate pop up?

[just1creation]

in column A i enter account numbers for the whole month. i would like to get a pop up or some sort of message if i enter the same account number...

[stevebriz]

yes this is possible...
Put this in your worksheet module

Please Login or Register  to view this content.

[Myles]

in column A i enter account numbers for the whole month. i would like to get a pop up or some sort of message if i enter the same account number... 

Supposing you make your entries in Column A, the following Event handler checks for any duplicates down the Column, and when one is sighted, the offending cells are colored [Red]. I prefer using color-flags to deploying Msgboxes, as the latter are intrusive.