Capital text and date formatting from a text box on a form

[Wales MB]

HI, I have just started this project and have hit a small snag.... (or maybe snags)

After entering the data in a form i would like to click the upload button the data from the text boxes move to sheet one.

The StaffInitials boxes data to convert to upper case and the DateBox3 boxes data to be in dd/mm/yyyy format.

Also if the person entering the date does so in the wrong format a error message appears like If Not IsNumeric.

Please Login or Register  to view this content.

[Norie]

Use IsDate to check for a date, use UCase to convert to upper case and CDate to convert to date.

[Wales MB]

The following error when testing
"Compile Error can not find Project or library"

Please Login or Register  to view this content.

And when testing this I had a MsgBox when entering a number instead of the date, but when entering 25.11.12 instead of 25/11/12 no MsgBox and the data went over to the spread sheet in the wrong format?

Please Login or Register  to view this content.

[Norie]

I think you need to goto Tools>References...

Check if anything is marked as MISSING.

If it is note it's name and uncheck it.

Then close Excel, reopen the file and try the code again.

As for the date thing, IsDate checks for a valid date not a valid date format, and that is a valid date.

Also, you say the date is in the wrong format on the sheet, how is the cell it's going in formatted?

[Wales MB]

Thanks for your help....

The first error is fixed so easy when you know how.

The column in sheet one is formatted to date dd/mm/yyyy but when typing in 11.11.12 on the form it pastes 11:11:12 AM in the sheet.

Is there a code to use that would also check a 'valid date format' or convert it to a 'valid date format'