Calendar Form

User avatar
adam
SilverLounger
Posts: 2347
Joined: 23 Feb 2010, 12:07

Calendar Form

Post by adam »

I'm having a calendar form where when the user selects a date the date gets copied to the textbox. But the earliest year the user could select is 2012 and not beyond that.

Is there any possibility to make the user select year 1920 and so on as I want to enter birth dates from that year.

Any help would be much appreciated. I've attached the workbook for reference.
You do not have the required permissions to view the files attached to this post.
Best Regards,
Adam

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Calendar Form

Post by HansV »

Change the line

Code: Select all

    Optional RangeOfYears As Long = 10, _
to for example

Code: Select all

    Optional RangeOfYears As Long = 115, _
Best wishes,
Hans

User avatar
adam
SilverLounger
Posts: 2347
Joined: 23 Feb 2010, 12:07

Re: Calendar Form

Post by adam »

Thankyou so much Hans. It worked really well.
Best Regards,
Adam