Error with Date Picker

[Molly Turner]

I created an userform in excel and placed a date picker on the form.
The date picker works fine and lets the user select the date, but
there is an issue when the information gets transferred to the
workbook. The date appears as 05/30/2012 on the date picker but when
the data is transferred to the worksheet it appears as 41059. How
can I fix this??

M

 

[Walter Briscoe]

In message <[email protected]
s.com> of Wed, 30 May 2012 11:04:51 in microsoft.public.excel.programmin

I created an userform in excel and placed a date picker on the form.
The date picker works fine and lets the user select the date, but
there is an issue when the information gets transferred to the
workbook. The date appears as 05/30/2012 on the date picker but when
the data is transferred to the worksheet it appears as 41059. How
can I fix this??

Try formatting the cell to which the date is loaded as mm/dd/yyyy.

In Excel 2003, I entered 41059 in a cell.
41059 is 41058 days since Excel's minimum date - 01/01/1900.

I then put focus on that cell.
Ctrl+1 or Format/Cells opens a Format Cells dialog.
Select the Number tab and the Custom Category.
In Type:, in place of General, enter mm/dd/yyyy.
I have an issue in a British environment. the formula bar renders it as
dd/mm/yyyy - the default date format.

Adapt to your environment.

Where do you find a date picker? It is likely to be helpful to supply
more information for your next enquiry.

 

[Gord Dibben]

Format the receiving cell as Date mm/dd/yyyy

You can probably do that in the code behind your userform but we can't
see that code.

Maybe...........

ActiveCell.Value = Format(Calendar1.Value, "mm/dd/yyyy")


Gord

 

[Gord Dibben]

Walter

OP is most likely using the Excel default Activex Calendar Control


Gord