Excel Date Picker Issue

[Triple6]

Hopefully someone can help me with but I'm trying to use the Date and Time Picker and the text isn't displaying correctly. When I first open Excel 2016 it looks partially cut off and displays a second window in the top corner that is clear, if I scroll it then looks fine. Also when I print the sheet it also looks cut off or squished just like it initially does on screen. Any ideas how to fix this?

 

[Keebellah]

Honestly, no idea.
What have to created? a Drop-Down list? When is it activated?
I'll download the file and take a look and see what the issue could be, I may be the ActiveX you used, don't know

 

[Keebellah]

Honestly, this is not a date pickr, it just shows today's date.
What did you use?
What is DTPicker1 , is that your creation?

 

[Triple6]

No, it was already in Excel.

I went to Developer Tools, Insert, selected More Controls from the ActiveX Controls, then scrolled down to Microsoft Date and Time Picker Control 6.0.

Is there an alternate way to get a date selection?

 

[Triple6]

So I just realized that it said "Microsoft Date and Time Picker Control 6.0 (SP4) so I updated the MSCOMCT2.OCX to get it to "Microsoft Date and Time Picker Control 6.0(SP6)" and now I cannot choose the date either and it only shows the current date.

Is there a another way to bring up a calendar for the user to choose that works in Excel?

 

[Keebellah]

I wrote my own calendar tool and that means you will need a macro-embedded file.
There is are quite a number of code snippets.
I personally do not like the ocx controls since they limit you when distributing the file.

 

[Triple6]

Okay, I guess I'll look for an alternative.