Battling to compare dates inputted in different methods

[alanb1976]

Hi all

I've searched around for this but cannot seem to come right.
I've got a worksheet where the user enters a month and year in the same cell. I'm then using VBA to try find a cell in another worksheet that lists that month/year.
For example, columns A to J list April 2015 to March 2016. The user will enter October 2015 and the macro should find the cell in column G. I can't seem to find the cell unless I capture the values as strings and compare exactly. But the user may input the date in a variety of ways which would leave that method useless (e.g. they may enter "Oct 15" or "01/10/2015"). How would I be able to convert the input to some type of date input and then compare the value of another cell formated in a date format?
I admit that I am useless when it comes to dates. Never used them before.

Thanks a lot
Alan

[Pepe Le Mokko]

Don't know about a VBA solution but you could use Data validation to force a constant entry format?

[alanb1976]

Hmmm..... good idea, thanks.
If I don't come right in VBA, I'll do that.