Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DTpicker number format
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
DTpicker number format
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
DTpicker number format
Explain what you mean by "wrong date" for us (that is, give us details).
Rick "ranswrt" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
DTpicker number format
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
DTpicker number format
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" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
DTpicker number format
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DTPicker Bug | Excel Programming | |||
DTpicker | Excel Programming | |||
DTPicker | Excel Programming | |||
set date on dtpicker | Excel Discussion (Misc queries) | |||
Number format based on number format of another cell in another workbook | Excel Programming |