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
Bookmarks