datetime.now function not working properly upon entering into spreadsheet.

[emilyloz]

Hi.

Im using a user form that automatically enters the date and time into a text box

Please Login or Register  to view this content.

I then use the information entered into the user form, and have it inputted onto a worksheet.

I have the cells in which it is added to formatted under custom: mm/dd/yyyy h:mm

on the user form, it shows the correct time and date, but once on the spread sheet, it changes the time to 12:00 am.

any ideas as to what is happening?

[JosephP]

how do you put the value back into the worksheet cell?

[emilyloz]

using this subroutine:

Please Login or Register  to view this content.

[JosephP]

always use CDate when passing dates back to a cell

Please Login or Register  to view this content.

for instance

[emilyloz]

Okay, I will try that. What does Cdate do?

[JosephP]

it converts a text representation of a date/time value into a true date data type using your regional settings

[emilyloz]

It's still doing the same thing. :/

It's occurring when I do this function:

Located on the sheet 'Home Page'
under the "Contractor" button. fill out form. and transfers to "Current Contractors" worksheet.

I attached my workbook. Password is "MillSteel"

perhaps this will help..

[JosephP]

works fine for me as long as you enter a time (your today's date buttons don't do that)

[emilyloz]

oh........... I was looking at the ones that only enter as the mm/dd/yyyy. I just need to change the format of the cells.

thanks so much!