vba user form calendar dropdown

[rjmdc]

i have excel 365 64 bit, i cant find a date picker option in user forms, also the mscomc2 doesnt seem to work in 64 bit
is there a soultion?

 

[dmt32]

i have excel 365 64 bit, i cant find a date picker option in user forms, also the mscomc2 doesnt seem to work in 64 bit
is there a soultion?

There seems to be an inconsistency in the availability of this control across all versions of of Excel - personally, I would avoid using it - there are plenty of Userform date pickers created that are free to download

here is one article that may help:Calendar Control for All Office versions - including Office 2016 64 bit (With Advanced Features) - E90E50

but there are plenty of others you can search for

Dave

 

[rjmdc]

i have tried so many free download version that say incompatible
please be more specific
what can i try that will work

 

[dmt32]

i have tried so many free download version that say incompatible
please be more specific
what can i try that will work

- cannot be specific but in general, Date Pickers created by others is just a userform with buttons & would just return a selected to use in your code. These "home brew" creations normally will work in most versions of excel.

helpful if you share with forum what it is you are trying to do in your project. Plenty here to offer guidance.

Dave

 

[rjmdc]

i want to create a form where DOB and Date of application, submission, completion etc. can be easily filled in with a date picker

 

[dmt32]

If you are looking for one that functions along same lines as the MS Date Picker and will work in all versions then not sure it exists but perhaps others here may know otherwise .

Dave

 

[rjmdc]

allow please anyone in the forum to offer advice
is there an alternate date picker that will work like the MS date picker for user forms

 

[rjmdc]

let me rephrase my question since i wasnt allowed to load as its own question
i do not have use of user forms or when they do allow some work it is very minimal, also i am taking a course but none of the lessons worksheets are supported as they are all in 32 bit
i was told that this is because i have 64 bit excel
leave the date picker aside
what do i do to transform 32 bit i to 64 bit