Results 1 to 11 of 11

Thread: [RESOLVED] [Excel] Microsoft Date and Time Picker Control 6.0 (SP6) not listed

  1. #1

    Thread Starter
    New Member
    Join Date
    Aug 2017
    Posts
    11

    Resolved [RESOLVED] [Excel] Microsoft Date and Time Picker Control 6.0 (SP6) not listed

    Dear guys,
    The Microsoft Date and Time Picker Control 6.0 (SP6) not listed in the "More Control" list .. and I'm not able to use the datepicker control.
    I'm using Excel 2010 (32-bit) running on windows 10 (64-bit)

    Would you please help me on that?

    Best regards,
    Shehata
    Name:  Image1.jpg
Views: 60634
Size:  53.8 KBName:  Image2.jpg
Views: 62692
Size:  34.6 KB

  2. #2
    PowerPoster jdc2000's Avatar
    Join Date
    Oct 2001
    Location
    Idaho Falls, Idaho USA
    Posts
    2,393

  3. #3
    PowerPoster
    Join Date
    Dec 2004
    Posts
    25,618

    Re: [Excel] Microsoft Date and Time Picker Control 6.0 (SP6) not listed

    you could use a userform to do similar, if you can not find a datepicker

    there is a datepicker addin
    https://www.rondebruin.nl/win/addins/datepicker.htm
    i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
    Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next

    dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part

    come back and mark your original post as resolved if your problem is fixed
    pete

  4. #4
    Fanatic Member dmaruca's Avatar
    Join Date
    May 2006
    Location
    Jacksonville, FL
    Posts
    577

    Re: [RESOLVED] [Excel] Microsoft Date and Time Picker Control 6.0 (SP6) not listed

    If this is a vb app that is going to be used by other people than yourself, I don't recommend using the date picker. As you've seen, the installation of the control is not consistent and it will break the file in the future. The date picker has caused support headaches where I work at in the past because of this reason. Just a word for the wise.

  5. #5
    Fanatic Member Spooman's Avatar
    Join Date
    Mar 2017
    Posts
    868

    Re: [RESOLVED] [Excel] Microsoft Date and Time Picker Control 6.0 (SP6) not listed

    Shehata

    Regarding your image .. 2 questions

    1. How did you get the selected col-row (K and 7) to have a backcolor of gold?
    2. I can click the Design Mode (mine is grey, not gold), but how do you get More Controls to appear?

    Spoo

  6. #6
    Fanatic Member dmaruca's Avatar
    Join Date
    May 2006
    Location
    Jacksonville, FL
    Posts
    577

    Re: [RESOLVED] [Excel] Microsoft Date and Time Picker Control 6.0 (SP6) not listed

    Hey Spooman,

    Gold seems to be the color used by 2010. That's the version I'm using and it's gold, also. More controls can be found by clicking "Insert" next to "design mode" and it's the bottom right choice under activex controls.

  7. #7
    Fanatic Member Spooman's Avatar
    Join Date
    Mar 2017
    Posts
    868

    Re: [RESOLVED] [Excel] Microsoft Date and Time Picker Control 6.0 (SP6) not listed

    dmaruca

    Hmmm.
    I'm not following you for some reason

    I'm using 2016. I clicked "Insert" (but couldn't find "design mode")
    Here is an image .. I split it in two to make it readable.

    left half

    Name:  excel1.jpg
Views: 62925
Size:  39.9 KB


    right half

    Name:  excel2.png
Views: 60444
Size:  19.2 KB


    1. As you can see, mine are grey backgrounds (col 9, row 13)
    2. Regarding "Insert" next to "design mode", did I click the right "Insert" ??

    EDIT-1:

    Oops, my bad ..

    If I do Developer > Insert > More Controls (lower right icon)
    I get the list. Thanks

    But, does something on this list enable me to get gold background?
    At first glance, scrolling through the list, nothing pops out as a solution.


    Spoo
    Last edited by Spooman; Aug 21st, 2017 at 05:16 PM.

  8. #8
    Fanatic Member dmaruca's Avatar
    Join Date
    May 2006
    Location
    Jacksonville, FL
    Posts
    577

    Re: [RESOLVED] [Excel] Microsoft Date and Time Picker Control 6.0 (SP6) not listed

    Look at the screenshot in the original post.

  9. #9
    Fanatic Member Spooman's Avatar
    Join Date
    Mar 2017
    Posts
    868

    Re: [RESOLVED] [Excel] Microsoft Date and Time Picker Control 6.0 (SP6) not listed

    You seem to have posted before my EDIT

  10. #10
    PowerPoster
    Join Date
    Dec 2004
    Posts
    25,618

    Re: [RESOLVED] [Excel] Microsoft Date and Time Picker Control 6.0 (SP6) not listed

    But, does something on this list enable me to get gold background?
    At first glance, scrolling through the list, nothing pops out as a solution.
    nothing to do with the colour of the row and column headers
    i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
    Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next

    dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part

    come back and mark your original post as resolved if your problem is fixed
    pete

  11. #11
    Fanatic Member Spooman's Avatar
    Join Date
    Mar 2017
    Posts
    868

    Re: [RESOLVED] [Excel] Microsoft Date and Time Picker Control 6.0 (SP6) not listed

    Pete

    While I had sorta come to that conclusion, thanks for confirming that.

    The color of the row and column headers is still something I'm wanting to deal with.
    If you have any thoughts, could you post in this new thread I recently started

    http://www.vbforums.com/showthread.p...lumn-backcolor

    Spoo

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width