none
A DatePicker and VBA RRS feed

  • Question

  • Hi,

    Could you recall me how to install and use a DatePicker in a VBA module in MS Project 2013. I used one 10 years ago, it was so easy to use that I don't remember :(

    Thanks



    • Edited by WLID1966 Saturday, September 17, 2016 1:45 PM
    Saturday, September 17, 2016 11:57 AM

Answers

  • WLID1966,

    Maybe and maybe not. I did a little more checking on my setup and let's make sure you have all the object library references you need. As a minimum you should have the following:

    Once you have those (except for you, versions for Project and Office 2013), see if you can now find the date picker control. For reference, the date and time picker control will be in the location indicated in the next screen shot. Note, if you have a 64 bit machine it will be "system64" instead of "system32" as I have.

    See if that helps.

    John
    • Marked as answer by WLID1966 Sunday, September 18, 2016 11:49 AM
    Saturday, September 17, 2016 7:21 PM

All replies

  • WLID1966,

    You and I must have been on a similar path. Several years ago (2007) I had a need to include a date picker in a userform I created and your question made me go back and research how I did it.

    Basically, the date picker tool must be added to the userform toolbox. This is what I just did in Project 2010.

    1. Open the VB Editor and go to Insert/Userform

    2. Insure the Toolbox is displayed.

    3. Right click on a blank area of the Toolbox and select Additional Controls

    4. In the Additional Controls window scroll down until you find Microsoft Date and Time Picker Control X.X (SPx)

    5. Select it and hit "OK". You should now see an icon for the date picker control in the Toolbox.

    6. Select and drag the control to the userform.

    Hope this helps.

    John

    Saturday, September 17, 2016 5:10 PM
  • Disappointment : I don't have Microsoft Date and Time Picker Control  :(

    NB: i'm using Project 2013
    • Edited by WLID1966 Saturday, September 17, 2016 6:05 PM
    Saturday, September 17, 2016 6:03 PM
  • WLID1966,

    Maybe and maybe not. I did a little more checking on my setup and let's make sure you have all the object library references you need. As a minimum you should have the following:

    Once you have those (except for you, versions for Project and Office 2013), see if you can now find the date picker control. For reference, the date and time picker control will be in the location indicated in the next screen shot. Note, if you have a 64 bit machine it will be "system64" instead of "system32" as I have.

    See if that helps.

    John
    • Marked as answer by WLID1966 Sunday, September 18, 2016 11:49 AM
    Saturday, September 17, 2016 7:21 PM
  • Hi John,

    I eventually retrieved my .mpp file (Project 2003) with the DatePicker.

    I checked it still works fin on Project 2003 and Project 2010 (32 bit)

    But the DatePicker controls are rejected by Project 2010 or 2013 (64 bit)

    So I have to find another DatePicker compatible with 32 Bit and 64 bit versions of Project.

    Thanks a lot for your help!


    • Edited by WLID1966 Sunday, September 18, 2016 6:22 PM
    Sunday, September 18, 2016 11:49 AM
  • WLID1966,

    You're welcome and thanks for the feedback.

    If you can't find the necessary 64 bit .ocx file, you might try checking your Project 2013 and Office 2013 to see if there are any un-installed components.

    John

    Sunday, September 18, 2016 6:01 PM