View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
White Horse White Horse is offline
external usenet poster
 
Posts: 5
Default Save default dtpicker value

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