DTPicker Default value

[kj135]

I've created a macro in Excel 2003 and I'm using DTPicker for the user to
select the date and time. For some reason the date and time defaults to when
the macro was written. How do I tell it to default to Now?

I've tried "DTPicker1.Value = Now", but for some reason it does not work.

Thanks inadvance for your help.

Steve

 

[Pranav Vaidya]

try using Now.Date

 

[Pranav Vaidya]

my earlier post may not work. I think just try
DTPicker1.Value =Date

 

[kj135]

Thanks for the help, but that did not work, maybe I'll try some other way to
input the date.

 

[Allen Geddes]

It works for me when I put it under UserForm_Initialize()

ex:

Private Sub UserForm_Initialize()
DTPicker1.Value = Now
End Sub