Search column for string and date then search adjacent cell and pop up message

I am trying to write VBA for the first time in many years and I am having trouble getting started.
I am trying write code that will do the following:

When a cell in column B is changed I want to check to see if it contains the string "ABC" followed by a date (i.e. "ABC7/29/14" or "ABC 7/29/14")

Where the date format is inconsistent (i.e. sometimes it would be 07/29/2014, sometimes 7/29/14, and sometimes 7-29-14)

If the cell does contain ABC followed by a date I want to check if that date falls within a date range.

If the date does fall within that range then I want to check the cell in the same row to the left (column A) to see if it contains the same string "ABC" followed by a date (i.e. "ABC7/29/14" or "ABC 7/29/14")

If the second cell does contain ABC followed by a date I want to check if that date falls within a second date range.

If all these conditions are met I want to have a message box pop up.

Thank you so much in advance. I have written a few things for this and I am just not getting good results or even things that run correctly every time.

Fiona

I do not have any data or I would have shared it. I am trying to create a form where the user enters information and if that information contains the specific letters ACB followed by a specific date the cell to its left gets checked for the same letters ABC and a different specific date and if both cells contain ABC and the dates specified dates I need it to pop up a message. :/ Not sure what else to give to help.

I do have this so far.

Please Login or Register  to view this content.

I know it isn't beautiful. Thank you for any help.