Date Value from UserForm moved to Sheet changes Format.

[msaric]

Hello Forum

I have a UserForm StudentAttendance which has a running Date and Clock. Code crude but works.

When I click Attendance Button, Data from UserForm is sent to Sheet2014. However the Date changes from Specified (Now, "dd:mm:yyyy") to Saturday, 0 January 1900.

I changed the column format in sheet but has no effect, always displays the same.

I have Included sheet for reference.

Any assistance would be greatly appreciated....Thank you again.

[HaHoBe]

Hi, msaric,

I changed the code a bit:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Ciao,
Holger

[msaric]

Hi Holger
Much appreciate your swift reply. Tried the revised code but ran into bug at the line.

.Cells(lngRow, 3) = CDate(TextBox1.Text)

Any suggestions please.

Just out of curiosity what does the lng in the variable denote in the code.

Trying to understand.

Thank you again.

[HaHoBe]

Hi, msaric,

Excel/VBA should show a error number on that line - could you please pass that number?

Row is a VBA keyword, I prefer to show what kind of variable I use (Type Long).

Ciao,
Holger