testing if one date exceeds today's date by a specific number of days with vba

Hi Dana,

Your issue is that when you clear the text box the macro is restarting because the text box value changes. Therefore your first line of code doesn't work because it is comparing today's date to a null value.
One way you could fix this is to add the following as your first line of code:

If TextBox11.Value = "" Then Exit Sub

All the best,
Stephen