how to validate the date in this format in VBA?

Thursday, July 10, 2014

I am using 3 separate Drop Down boxes for taking day ,month and year respectively in VBA. But , I don't know how to validate these three either individually or together Can someone please suggest me the code and/or function to do so.

Thanks in advance.