Should I use calendar control to accept dates from user?

**welchs101** · 03-02-2012, 10:31 AM

Hi,

I started using a control called "Calendar Control" via a userform to accept date inputs from the user. I went to this userform/control because i created a macro which i had to send overseas and it just seem to simplify all the issues which surround dates.

Here is a link i found which references this.

http://www.fontstuff.com/vba/vbatut07.htm

My issue is this:
1) I sent my macro to someone over seas and they did not have the calendar control installed on their computer. I was under the impression that this calendar control was something that was part of the standard install.

2) I also read that this calendar control may not work with 64bit machines.

So, while i REALLY REALLY REALLY like this userform / calendar control i am starting to think maybe i should not use it.

Any thoughts? Also, is there something else out there that is similar that does not have the restrictions like this one.

**jaslake** · 03-10-2012, 04:10 PM

Hi welchs101
Check this link Post #1 Calendar10.zip...I use this calendar control almost exclusively because it doesn't require mscal.ocx.
http://www.ozgrid.com/forum/showthread.php?t=30327

**royUK** · 03-11-2012, 02:37 PM

See my alternatives here

http://excel-it.com/free_addins.htm

As far as I am aware you can't download from Ozgrid without joining

**jaslake** · 03-11-2012, 08:05 PM

Hi welchs101
royUK is correct

As far as I am aware you can't download from Ozgrid without joining

When I registered several years ago it was free (albeit, lots of advertisements). As far as I know, it's still free. I've not used royUK's referenced code because I can't see it...the AddIn is password protected...and, if you're distributing, you'll also need to distribute the AddIn. Not a big deal distributing...having the ability to modify the code, in my mind, is an issue.

The link I referenced is described as "Written and provided as freeware by: Phil Johnson". It's not an AddIn...it's code in the workbook being distributed. The code is accessible and can be modified as you wish.

There is other code I use...it's less intuitive as it includes a Class Module to define all the Buttons in the Calendar. If you're interested, post a workbook that demonstrates what you have. I'll see if I can adapt the code.

**royUK** · 03-12-2012, 02:50 AM

There's actually three examples on the link that I provided. Only the addin is protected.

**jaslake** · 03-12-2012, 11:43 AM

@royUK
Thanks..I've been searching for some time for frmCalendarv1.02. It's code is what I am alluding to here

There is other code I use...it's less intuitive as it includes a Class Module to define all the Buttons in the Calendar

but have been unable to find it. An OP had the code in a workbook I helped with but I didn't know where the code came from.

It took me a while to find it on your site...for others that are looking...it's here "There is also an example of how to use the ActiveX Calendar Control Another way would be to use ComboBoxes on a UserForm, get an example here or a UserForm calendar is available with code & examples of how to use it. Free download..."

I like to attribute code I borrow...is this code yours such that I should attribute to you?

**royUK** · 03-12-2012, 02:59 PM

This is a Thread that refers to the Calendar Form

http://www.excelforum.com/developmen...ndar-form.html

It's mainly my code as I remember, but probably includes other bits & bobs.

I have another one that I tend to use now that allows me to select a date Format as well.

**jaslake** · 03-12-2012, 09:46 PM

@ royUK
I assume this link refers to frmCalendarv1.02. However, the link is no longer active so I can't tell. Has this code been posted (or a reference to it)

I have another one that I tend to use now that allows me to select a date Format as well

**royUK** · 03-13-2012, 03:20 AM

I don't know what's happened to the links in that thread. I don't recall using Send Space, but the changes on the Forum have lost a lot of attachments. It was the form that I added to my site.