Why does a "do until" loop stop the subroutine?

Hello,
Any idea why the first loop stops the sub, it doesn't proceed to the second loop..

Please Login or Register  to view this content.

It is not proceeding because you are asking for a string, and keeping it a string.

But also, you will always have problems with ambiguous dates - VBA is US-Centric for dates, so 5/7/2015 will be May, not July.

So try

Please Login or Register  to view this content.

Better would be to use a calendar control - here's a workbook with an example that will work:

Simple Calendar.xlsm

@Bernie, Thx for your help! I'll use your method for the weight question also. But how do I verify that the user enters a valid date. Right now running your code, if I enter no date at all (into the input box) the code just stops.. the do until loop was intended originally to force the user to enter a correct value into the inputbox..

You need to handle that error:

Please Login or Register  to view this content.

@Kyle - I'm trying to refrain from form in this specific case. Thanks anyway.
@Bernie - It works just fine! and i'll also seize the opportunity to learn more about "ErrHandler"..