[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
Attachment 150755Attachment 150757

Possibly useful links:

https://excelribbon.tips.net/T002080...te_Picker.html

http://danielcurran.com/instructions...ontrol-60-sp4/

https://social.technet.microsoft.com...eitproprevious

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

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.

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

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.

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

Attachment 150909


right half

Attachment 150911


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

Look at the screenshot in the original post.

You seem to have posted before my EDIT

Quote:

---

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

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