Date not found in range?

[RustyNail]

Hello folks,

Upon a Worksheet_SelectionChange() event, a date is inputed in current cell "E2" and has a date of 11/02/2019.

So, I type in the date and when I press enter, the Worksheet_SelectionChange() event is fired.

please see code below:

Please Login or Register  to view this content.

A couple of cells within the range E2 to E306 have the same date in them : 11/02/2019.

But the the Value not found message always comes up even though I know duplicates of the
date exist in the range??

What am I doing wrong?

I am looking to refuse the entered date if it already exists in the range!

Thanks so much for any help and feedback ?

rn

[bakerman2]

How do you call the Security sub from your event code ?
Also use Change-event instead of SelectionChange because my guess is that now it's looking at the wrong cell .

[RustyNail]

Hi Bakerman2,

Thanks for replying!
Hmmm Change event doesn't work because in reality, the contents of the cell are changed by a calander date picker!

And I don't know why the change event doesn't fire when date picker calendar modifies the
date ??? A date picker is available in every cell in the E column.

So anyways here's the whole code:

Please Login or Register  to view this content.

[bakerman2]

Try this.

Please Login or Register  to view this content.

[RustyNail]

Hi Bakerman2,

Somehow this line:

Please Login or Register  to view this content.

Does not return the calendar value picked???

Really confusing this date picker stuff

thanks

[bakerman2]

Works fine for me.
I've left out 3 dates to choose from in the example file.

[RustyNail]

Ok, after so many changes I finnaly was abe to get it to work!

Thanks bakerman2!

rn