I designed Userform1 that has DTPicker1.

In the VBA editor, Properties, DTPicker1, Value is 02/17/07. It is
always this date unless I change it in design mode.

At runtime, if I select the current date for this control, can I
replace 02/17/07 with the current date (or date selected from the
calendar), save the file, so that next time I open the file, the value
will be the prior selected date?

Thanks,
Mike

Hi White Horse

One way

You can use a worksheet cell to copy this date in and in this event in the userform

Private Sub UserForm_Initialize()

End Sub

Set the value for the DTPicker1 (cell value)

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"White Horse" wrote in message oups.com...
I designed Userform1 that has DTPicker1.

In the VBA editor, Properties, DTPicker1, Value is 02/17/07. It is
always this date unless I change it in design mode.

At runtime, if I select the current date for this control, can I
replace 02/17/07 with the current date (or date selected from the
calendar), save the file, so that next time I open the file, the value
will be the prior selected date?

Thanks,
Mike