DTpicker number format

[ranswrt]

When I use DTPicker control to put a date into a cell, it puts the wrong date
in. Do I need to change the number format in the cell or on the control? I
tried

DTPicker1.Value = Format(DTPicker1.Value, "mm/dd/yy")

and that didn't work.
Thanks

 

[Jim Thomlinson]

Why not just set the linked cell property of the control to a cell on the
sheet. Wht the sheet in design mode right click the control and select
Properties. In the Linked Cell property add the cell reference. See if that
fixes your date issue...

 

[Rick Rothstein \(MVP - VB\)]

Explain what you mean by "wrong date" for us (that is, give us details).

Rick

 

[ranswrt]

The control is on a userform. So I set the date to a variable then use that
to put it into a cell on the worksheet.

 

[ranswrt]

When I set the date to 7/28/08 the date when it is put into a cell on the
worksheet is 1/0/1900

 

[ranswrt]

I would like the date in mm/dd/yy format if possible.