Check entries dates before add new entrie

[Undo]

Hello

in my table while I click edit, a userform will appear for editing
I am looking to proofing that the new inputted date is not facing another date circle with the same CODE only
date circle= 2 days before the date, 2 days after the date, the exact date
and show msbbox then exit sub
note that the edited entire should be outside the proofing round because its as a new input

[oeldere]

Is data validation on option?

If so add the expected results in your excel file.

[Artik]

Please Login or Register  to view this content.

Artik

[Undo]

it should check all records with same CODE