Set date time picker to null (blank)

W

Webtechie

Hello,

I have a form with a date time picker. I'm using Excel 2007. When the form
opens, my boss wants the date time picker to be blank. I'm not sure if that
is possible and had previously set it to current date. I've tried setting it
to vbNULL. This sets the value at 12/31/1899.

So I thought I would at least ask the group, can you make the date time
picker blank when first opening a form? During data entry, the data entry
person will set the date as appropriate.

Thanks.

Tony
 
W

Webtechie

That is the link I used to set it to vbNull. However, setting it to vbNull
sets the date time picker to 12/31/1899. It is not null or blank.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Date and time picker control 3
Date Picker Default? 1
set DateTimePicker value to null issue 1
Time picker 1
Date & Time Picker Properties Question 19
Conditional Formatting for Date Picker field 1
Date & Time Picker Control 6.0 - another challenge (for me) 4

Top