User Form Pop up Calendar Function

[Nathan95]

Hey All,

So i ended up using a user form and everything works perfectly. The only issue is to select the start and end date I called upon the Calendar Function in VBA, which works fine on my pc, However if i send the file to another user, since they don't have the calendar function enabled the calendar does not populate and instead they just get a black form (inplace of the calendar). Seeing as this file is going to be used my a large number of people I cant manually get them to add that function to their VBA.

Is there a way to automatically call upon and assign the calendar function to each user when they press the button (at the start of the code) that way the calendar will appear for them?

 

[dmt32]

Hi,

As mentioned in this thread Date picker in user form?
for OP with similar issue, there is no consistency of availability of the date picker control for all versions.

Personally, I would suggest that consider an alternative approach like one shown in the link or, if really want a date picker in your project, search out one of the many home creations like for instance, this one Trevor Eyre (but there are many others)

You can download for free.

Dave