using max and min date in calendarform CalendarForm v1.5.2

[prabhakaranpd]

i am using CalendarForm v1.5.2 by Developed by Trevor Eyre

it is a excel vba date picker....

i am using it to enter a date range.....start date and end date .... into textbox 1 and 2 respectively

Please Login or Register  to view this content.

i want to set maximum and minimum dates....
maximum date is today
minimum date for textbox2 is textbox1 date


i don't know how to configure that calendar form...

can someone please help me

[torachan]

Used extensively on this userform.
The code may be a useful guide.

https://www.excelforum.com/excel-pro...ml#post5352501

[prabhakaranpd]

thanks torachan for your kind reply......

your post shows how helpful you are to others.....much appreciated...

i went through the post....

but myself being a novice.... am unable to make out much from your post....


i have attached a file with the user form

please see if you can help me



what i was able to make happen is select either today's date or select a date range....
on clicking textboxes or optionbutton2, calendarform shows and we can select two dates....




i want to make a code ....so that the date in textbox1 is never a future date
and date in textbox2 is never a date which is behind the date in textbox1



for example... if user selects 10/06/20 in textbox1, then he should not be able to select a date before 10/06/20 for textbox2

[torachan]

Give the attached file a try.
The basic calendar was distorted when opened on my computer so I have used the advanced calendar choice.
The initial calendar is on a double_click and the check is done on the change event.

[prabhakaranpd]

excellent....!!
thank you very much for your help....

actually i wanted to set minimum and maximum date argument in the calendarform....

your workaround servers the purpose.....


thanks once again....