Set Date Picker Control to current date

[Patrickw]

I have tried code in the userform initialize routine as follows:

DTEPicker.Value = Date

and

DTEPicker.Value=Date$

Neither works to set the date first displayed in the date control to
the current system date.

 

[Doug Robbins - Word MVP]

On my system, the current system date appears as the selected date without
the need for any code.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

 

[Graham Mayor]

The DTEPicker displays the current date by default
See also http://www.gmayor.com/popup_calendar.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Patrickw]

I'm using the Microsoft Date and Time Picker Control, Version 6.0

It requires a value in the properties

 

[Graham Mayor]

I'm using the Microsoft Date and Time Picker Control, Version 6.0

It requires a value in the properties

Which is inserted by default

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Patrickw]

Is there a better simple date/time control to use that I can install
on all my Word 2003 and Word 2007 machines?

 

[Graham Mayor]

You could use the one I pointed you to in my original reply -
http://www.gmayor.com/popup_calendar.htm - but whether it is better or
simple I will leave you to judge.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Steve]

I was having the same problem. I figured out it was because I have the date
picker invsible when my userform opens. I set it to visible, change the date
to current date, then make it invisible again and it works fine. You should
check that on yours and also check if the form where it is located is the
active form when you make the call to change the date. It seems the date
picker is very picky (no pun intended).