Restrict Input Start and End Dates to One Quarter

[Gos-C]

Hi all,

I have the following code:

Please Login or Register  to view this content.

How do I restrict the input sDate and nDate to the beginning and end of Q1, Q2, Q3 or Q4?

Thanks,
Gos-C

[Fettertiger]

Hi Gos-C,

I have replaced the Input boxes by a userform, because I think this is more elegant. The part that determines if it is within the same quarter can be found in the code of the userform within the attached workbook.Quarter.xlsm.

I am pretty sure you can reapply easily.


Regards

Theo

P.S. Don't forget to close your thread if your issue is solved. Consider to thank those who helped you, by clicking on the star to the left of the helpers reply!

[Gos-C]

Hi Theo,

Thank you very much for your help.

I am trying to force the user to enter only the beginning and end dates for the quarter. For example, 1/1/12 and 31/3/12 for the Start Date and the End Date, respectively, for Q1 of 2012. However, you are allowing any date in the quarter.

Gos-C