Custom Date Picker Control

I am developing a form for entering data into Excel and for some of the fields have dates as values. I really like the built-in date and time picker control for this, except that I want to be able to change the background colour of the part of the control that looks like a combo box. And that is simply not possible with the standard date and time picker. How can I get around this problem

I have been trying to create a custom control to emulate the date and time picker by combining a standard combo box with a hidden month view control that becomes visible when the user presses the dropdown button of the command box, but have been having a lot of trouble with this.

Answer this question

Custom Date Picker Control

Lubo Birov
The "send to back" button is a button in the VBE used for changing the visual ordering of controls on a form. Its application can be emulated with the following menu control: Format->Order->Send to Back.
J. Zhang
per our support engineer:

Hi,

Thank you for contacting Microsoft ISV Partner Support.

Your two question is about the vba control Date Picker Control.

1) how to change the back color of Data Picker text box

Based on my experience, we just can change the CalendarBackColor, not the textbox.

Data Picker is just a control for VBA, so it has not so many rich properties.

2) what’s the "send to back" button, could you please specify it

-brenda (ISV Buddy Team)
David Noy
After further investigation, the engineer has determined that this is a bug.

This issue that the "send to back" does not work on the control "Date Picker Control is a bug and I have submitted it to the product team. Unfortunately we have no workarounds that the product team can offer us.

Sorry I don't have a solution to share with you, but appreciate that you brought the issue to our attention.

-brenda (ISV Buddy Team)
gfroelich
Another thing is, even if I select the DTPicker control and click on the "send to back" button, the DTPicker still shows up on the form on top of any other controls. The DTPicker is a nice and useful control to use for entering dates, but it seems to lack some significant functionality that really should be inherited from the basic control class.
Custom Date Picker Control

Answer this question