bergjes
12-18-2012, 01:15 PM
Hi,
hope someone can help me out.
I'm trying to build a userform for entering data which will be written to a seperate worksheet for further analysis.
I'm a noob with VBA.
I found some code which I'm trying to adapt to my own needs.
I'm almost there, but here is my problem:
When writing the data to my seperate worksheet (DataInput), the date format is beeing altered to English, while I want it to be "dd-mm-YYYY".
I tried for ours to find how to change it, but I can't find it.
Hope you can?
The file I'm using is attached.
Thanks.
Erik
hope someone can help me out.
I'm trying to build a userform for entering data which will be written to a seperate worksheet for further analysis.
I'm a noob with VBA.
I found some code which I'm trying to adapt to my own needs.
I'm almost there, but here is my problem:
When writing the data to my seperate worksheet (DataInput), the date format is beeing altered to English, while I want it to be "dd-mm-YYYY".
I tried for ours to find how to change it, but I can't find it.
Hope you can?
The file I'm using is attached.
Thanks.
Erik