Save default dtpicker value

W

White Horse

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
 
R

Ron de Bruin

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)
 

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

Top