Excel VBA Date Picker on User Form other than Microsoft Date Picker

[Jaye Cavallo]

Hello,

I am using Excel 2016 for work with a user form that I created in a earlier version of Excel (2013). On that form, I made use of a date picker that was not the Microsoft Date Picker, mainly because when I shared the Excel file with my colleagues, I found that the MS Date Picker had to be installed on all of their individual computers. The IT team did not want to install the ocx file on all of the computers. Thus, I made use of another date picker found in the additional controls for the toolbox. However, there is not a date picker available in the upgraded version of Excel 2016. I get an error in my form when I launch the form because the object does not exist.

Can anyone recommend a solution for how I can make use of another date picker option on my form? The only other option I see is the Outlook Date Control which does not work on my form.

Any help is appreciated.

 

[Domenic]

Here are a couple alternatives, among many...

Date Picker | xl-central.com

Displays a calendar, and prompts the user to select a date.

xl-central.com

Excel VBA date picker - Trevor Eyre

Senior front end software engineer

trevoreyre.com

The first one is a very simple one, whereas the second one is fully customizable.

Hope this helps!

 

[Jaye Cavallo]

Here are a couple alternatives, among many...

Date Picker | xl-central.com

Displays a calendar, and prompts the user to select a date.

xl-central.com

Excel VBA date picker - Trevor Eyre

Senior front end software engineer

trevoreyre.com

The first one is a very simple one, whereas the second one is fully customizable.

Hope this helps!

Hello, thank you for the response. Are these solutions that I can easily add to my user form so users can select a date and it populates on the user form?

 

[Domenic]

Yes, for example, to return the selected date to a TextBox on your UserForm, let's say TextBox1...

    Dim userDate As Date
    userDate = frmCalendar.selectDate(Me.TextBox1.Value)
    
    If userDate > 0 Then
        Me.TextBox1.Value = userDate
    End If

Hope this helps!

 

[Jaye Cavallo]

Yes, for example, to return the selected date to a TextBox on your UserForm, let's say TextBox1...

    Dim userDate As Date
    userDate = frmCalendar.selectDate(Me.TextBox1.Value)
   
    If userDate > 0 Then
        Me.TextBox1.Value = userDate
    End If

Hope this helps!

Hi, I am sorry, but I am having a brain cramp. I downloaded the xlc date picker and extracted the files. I don't understand how to add the date picker to my form where I need it. I have attached my form and the blank space next to "Date*" is where my previous date picker control was placed. I guess the previous date picker is not compatible with the latest version of Excel.

 

[KalvinZ]

Hi all- I can't seem to add this date picker to a userform either.. Can someone help?

 

[Domenic]

Here's a sample workbook that adds the date picker to a userform...

http://xl-central.com/samples/xlc-date-picker-userform.xlsm

Hope this helps!

 

[KalvinZ]

Thank you Domenic!

 

[dmt32]

Can anyone recommend a solution for how I can make use of another date picker option on my form?

Have a look at third a party Excel VBA date picker (others are available) & see if any help to you.

Others here may have alternate suggestions.

Dave