Hi Specialists,

I'm dutch-speaking so forgive me my english a little bit.... Thanks

I've created a form named "frmNieuw" withe different kind of fields. 3 of them are a txtfield named "Start" - "Einde" - "Einde volgend jaar"

Ik you look in the sheet you can see what the form soes when you click the blue button "Nieuw lijn..."

A new line is created, the form starts up and after cklicking de "Toevoegen" button all the inputs go to there cells.

So far no problem...



However the " inputs "Start" - "Einde" - "Einde volgend jaar" goes to the colum M - N - O and Excel changes the properties for example 15-01-16 becomes 01-15-16 even when the cell propertie is set to dd-mm-jj

In the comum M it's correct, but in the colums N an O it goes sometimes wrong, depend on the date.

My question is : Is it possible to set a date propertie in a field of my form? And is it also possible to set a inputmask (like in access) for these fields? for example : --/--/--


In attachement a copy of the excel file



Thanks in front for your sollutions.

Best regards

Pascal

Attached Files

Voorbeeld.xlsm (194.7 KB, 9 views)