Show Datepicker as blank in userform

[thechad]

Hi all,

I have a datepicker that I want to show as blank when a UserForm is opened thus forcing the user to select a date and not miss it. The name of my DatePicker is "OffenceDate"

Seems like a simple solution but not finding anything so far.

Thanks,
Chad

 

[sijpie]

The way I handle these things normally is to disable the OK button on opening the userform. Then I have a small sub that checks all required input (textboxes, radiobuttons, checkboxes, datepicker, etc). it sets the OK button to enabled (when all OK) or disabled (when something missing).

For each control, the control_change() sub calls this check sub.

That works foolproof.