First of all,
you're setting MyRange to be from column  A, row  11, to column H, row "lastrow".
simply set to H11, like:
.Range("H11: H" & lastrow)

Also, be aware that you're doing string comparisons.
NOT date  comparisons!

That means that if the user enters 03/07/2008 or even 7-Mar-2008, it will NOT
find the records with 3/7/2008 as a match.

Consider first using the isdate(result) function to ensure that it is a date
format,
then use the datediff() to see if the dates match.