-
Aug 17th, 2017, 02:02 PM
#1
Thread Starter
New Member
-
Aug 17th, 2017, 02:33 PM
#2
Re: [Excel] Microsoft Date and Time Picker Control 6.0 (SP6) not listed
-
Aug 17th, 2017, 04:17 PM
#3
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
-
Aug 18th, 2017, 04:50 PM
#4
Fanatic Member
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.
-
Aug 19th, 2017, 02:53 AM
#5
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
-
Aug 21st, 2017, 04:05 PM
#6
Fanatic Member
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.
-
Aug 21st, 2017, 05:03 PM
#7
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
right half
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.
-
Aug 21st, 2017, 05:05 PM
#8
Fanatic Member
Re: [RESOLVED] [Excel] Microsoft Date and Time Picker Control 6.0 (SP6) not listed
Look at the screenshot in the original post.
-
Aug 21st, 2017, 05:22 PM
#9
Re: [RESOLVED] [Excel] Microsoft Date and Time Picker Control 6.0 (SP6) not listed
You seem to have posted before my EDIT
-
Aug 22nd, 2017, 04:42 AM
#10
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
-
Aug 22nd, 2017, 06:48 AM
#11
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|