Edit code to loop error msgbox and inputbox until valid date is entered by user.

Hi guys, need your expertise here, my current code asks the user to specify the dates for fDateA to fDateC in the inputbox, the problem is the custom dates might not be available, can anyone helpe me edit the code to loop the inputbox to ask back the user to reenter another date, when the date is unavailable, and loop the error message until a valid date has been entered.

For example lets say user enters in inputbox for fdateA "9/9/2012", but data for date "9/9/2012" doesnt exists, so the code would prompt an error msgbox and restart the inputbox for user to reenter another choosen date, and loop until date choosen is valid.

The same goes for fdateB and fdateC. Please help out.

Please Login or Register  to view this content.

Thanks in advance.