Malfunctioning: Microsoft Date and Time Picker Control

[KDavidP1987]

Greetings,

I have a question for which I cannot find the answer to anywhere. I'm using the Microsoft Date and Time Picker Control in a form at the request of leadership who want to choose the date for the form. The info doesn't go anywhere, it just shows up on print outs.

The problem: This control is SUPER fidgety. Sometimes it shows up all skewed (large text inside, or otherwise a mess). Sometimes this resolves itself after the spreadsheet has been open for a minute, sometimes not and it has to be reloaded.

Has anyone came across this before? Any reason the appearance of the form sometimes works perfectly and sometimes looks whacky?

Sincerely,
Kristopher

 

[RoryA]

Are you talking about a userform, or a worksheet "form"?

 

[KDavidP1987]

Are you talking about a userform, or a worksheet "form"?

Wish I could link a picture, lol. I am referring to the DEVELOPER TAB -> INSERT -> Active X Controls -> More Controls -> Microsoft Date and Time Picker. That I'm aware of, it seems to be the only date picker available in Excel?

It looks horribly skewed, like it isn't loading correctly.

 

[RoryA]

So you're putting it on a worksheet, not a user form. Unfortunately, activex controls really aren't all that stable on worksheets.

 

[KDavidP1987]

That's unfortunate! Yes, it is going into a worksheet, because leadership wants a option to pick the date on the sheet. The sheet is a sort of form, but it isn't designed as a form.

Is there any other date picker available in Excel?

 

[RoryA]

No. If you really need to use that, I'd suggest you add it to a form and show the form from say the double-click event of the worksheet.