CODEWITHSUNDEEP
exceldatetimepickervba
Nikhil
Nikhil

Reputation: 1309

adding customized text to excel "date time picker" control

I have an Excel sheet with the 'Microsoft date time picker control'.

The content in the control, by default, when the sheet initializes is the current date.

I wish to display some text in the control when the control is first initialized...something like "Please select a date".

Can this be done? If yes, how? Do we use a macro? Can we modify a property through code?

enter image description here

Upvotes: 2

Views: 648

Answers (1)

vulkanino
vulkanino

Reputation: 9134

No, it's not possible (and not advisable). The Value property is of type date-time.

Upvotes: 1

Related Questions