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

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

Jim Thomlinson


"ranswrt" wrote:

> 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

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

Rick


"ranswrt" <(E-Mail Removed)> wrote in message
news:8E31B149-B45F-4C57-A382-(E-Mail Removed)...
> 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

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.

"Jim Thomlinson" wrote:

> 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...
> --
> HTH...
>
> Jim Thomlinson
>
>
> "ranswrt" wrote:
>
> > 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

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

"Rick Rothstein (MVP - VB)" wrote:

> Explain what you mean by "wrong date" for us (that is, give us details).
>
> Rick
>
>
> "ranswrt" <(E-Mail Removed)> wrote in message
> news:8E31B149-B45F-4C57-A382-(E-Mail Removed)...
> > 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
>
>

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

"ranswrt" wrote:

> 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