Excel Datepicker to show by default NA value

krishhi

Active Member
Joined
Sep 8, 2008
Messages
328
Hello, Is there a way to make a Default Value N/A for Datepicker. So, user will know that there is no date selected for a particular.

Thank you in advance.
 

Domenic

MrExcel MVP
Joined
Mar 10, 2004
Messages
19,013
One possibility might be to set the CheckBox property to True. This way, when the the userform is shown, the datepicker will have an unchecked checkbox and the datepicker itself will appear somewhat greyed out. Then, once a date is selected, the checkbox gets automatically checked and the datepicker will appear without being greyed out. And, in code, you can either assign Null or an empty string ("") to uncheck the checkbox and grey out the datepicker...

Code:
DTPicker1.Value = Null
or

Code:
DTPicker1.Value = ""
Hope this helps!
 

Forum statistics

Threads
1,082,586
Messages
5,366,476
Members
400,892
Latest member
lamarh755

Some videos you may like

This Week's Hot Topics

Top