Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Format returned from Userform to Excel worksheet
Hi,
I have a routine vb where I have a form (RXWfrmDate) with the date (m/d/yyyy) for the user to pick a date for download to specific cell on the worksheet. Sub RXWDate() Dim DateIN As Date Application.ScreenUpdating = False RXWfrmDATE.Show If frmCANCEL = True Then Exit Sub ActiveWorkbook.Unprotect Sheets("Reactor Water").Select ActiveSheet.Unprotect Range("C3") = DateIN Range("C3").Select Selection.NumberFormat = "m/d/yyyy" Exit Sub Application.ScreenUpdating = True End Sub However, the date that shows on Range "C3") after user input is 01/00/1900. What am I missing? Appreciate any help. Thanks. Lily |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Get a date to display in date format on a UserForm | Excel Programming | |||
Date Format in Userform | Excel Programming | |||
Date format in userform | Excel Programming | |||
I need today's date returned as date format in formula | Excel Discussion (Misc queries) | |||
Date format from UserForm | Excel Programming |