Adding a Calendar to a User Form

[00Able]

I have a imported a calendar into the VB section of my worksheet. I was hoping I could add it into my Userform, but it is showing up as an independent user form. Was hoping I could have this calendar tie into the date of the userform. Can someone with more programming experience look at this and tell me if this is possible?

I initially thought it was going to be a no brainer...so much for that...ugh

[mojo249]

It would help if you attached your file.

Basically, you want to add some code to the control on your main form (in the example below it's a textbox called txtChangeDate) on the main form which opens the calendar form (frmCalendar) when you enter it:

Please Login or Register  to view this content.

Then add some code to the calendar form so it adds the selected date to the textbox when the calendar is clicked:

Please Login or Register  to view this content.

[royUK]

I would steer clear of the activeX controls, see the alternatives in the DatePicker section

[00Able]

I would steer clear of the activeX controls, see the alternatives in the DatePicker section

I agree with you Roy, and I based on your previous suggestion, I checked out the same site and downloaded a link, I exported a calendar and imported into my worksheet, but I am not sure how to put the two pieces together, I was hoping that when the user clicked on the date field on the userform, the calendar would then pop up to allow them to choose a date, and input the selection into the proper field.

Is this possible?

[00Able]

It would help if you attached your file.

I apologize, I did initially attach the file, however, I failed to realize it was to large to attach, I have made the necessary changes and attached it to the first thread now.

[royUK]

Try zipping the file before attaching

[00Able]

Here is the file, check the code to see where the calendar is

[royUK]

This uses my Calendar Form

[00Able]

This is excellent, my only question is, How did u make it do that, as this is just a sample file, and I want to add this option to a couple of other forms?

[royUK]

The codes all there. Just drag & drop all my code to your new workbook.

Then I added some code to the TextBox to display the Calendar and changed the Tab order of the Controls on your UserForm so that the Date textbox was not selected on initialisation which would have displayed the Calendar.

[00Able]

ok closing this issue, as that part is fixed but opening a new one that is more relevant..

[timarcarze]

The codes all there. Just drag & drop all my code to your new workbook.

Then I added some code to the TextBox to display the Calendar and changed the Tab order of the Controls on your UserForm so that the Date textbox was not selected on initialisation which would have displayed the Calendar.

Hi Roy,

I have tried using the similar code in attached model and am receiving an error. Do you know why this does not work in same manner as your form?

Thanks

[royUK]

The only error that I can find is caused by missing named ranges.

Please Login or Register  to view this content.

The calendar code works fine

[timarcarze]

The only error that I can find is caused by missing named ranges.

Please Login or Register  to view this content.

The calendar code works fine

royUK

Not sure I understand how to set those list Names? Could you advise based on my model?

I am also receiving a "run-time error 424 - Object Required" each time I try to run the script.

The debugger points to

Please Login or Register  to view this content.

Do you know why this is the case and how to fix?

[snb]

An alternative in the attachment.

[ktixx]

This uses my Calendar Form

Amazing, works perfectly - Thank you!!!