month capacity alert

[khaledhamdy]

Guys,

I have two text boxes on my user form"start date" & "end date", and I need to compare their values with a table in the excel workbook.

for example, if the start date is 4/21/2018 and the end date is 5/15/2018.

I need the VBA to search in a table in sheet2 if any of these months has reached its allowed capacity (which is the number of used days, assume this number is 30 days) and give a warning message


this issue is related to my other thread

https://www.mrexcel.com/forum/excel...number-days-particular-month.html#post5056625

thanks in advance guys for your valuable support