Search for duplicate entry on two criteria within date range

[glynnhicks]

Hi all,

I'm having difficulty trying to use a userform to search bring up a warning message if two criteria within a given date range is matching.

I have a simple userform that adds data to a spreadsheet. What I'd really like to happen is a warning sign to appear if dates entered match two criteria already within the spreadsheet.

I've tried to research this by searching through different threads but I can't find anything that looks matching criteria between two dates. I've had no success using < > but that's my lack of VB knowledge.

I was hoping to enter data into the userform and on clicking confirm a message would come back to state what the matching criteria is.

Would appreciate any help?

Thanks all.

Glynn