DTpicker number format

R

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
 
J

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...
 
R

Rick Rothstein \(MVP - VB\)

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

Rick
 
R

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.
 
R

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
 

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