markyc
09-29-2006, 03:56 AM
Please help.:banghead:
I have creating a userform in excel that is asking the using to enter dates of work completion, once dates have been entered by user the dates are then entered by macro into a master record.
I have got the macro working fine, but I having problems with date formats.
If user enters the date as 02-May-06 this is entered into the master OK, however if entered as 02-05-06 it is being entered into master as 05-02-06. I know this is the US date format.
Is it possible using the Textbox1_change that change the format of the date in that textbox to dd-mmm-yy.
I would like to say to users enter the date as dd-mm-yy and form or macro changes the format to dd-mmm-yy.
Any help would be excellant
Rgds
I have creating a userform in excel that is asking the using to enter dates of work completion, once dates have been entered by user the dates are then entered by macro into a master record.
I have got the macro working fine, but I having problems with date formats.
If user enters the date as 02-May-06 this is entered into the master OK, however if entered as 02-05-06 it is being entered into master as 05-02-06. I know this is the US date format.
Is it possible using the Textbox1_change that change the format of the date in that textbox to dd-mmm-yy.
I would like to say to users enter the date as dd-mm-yy and form or macro changes the format to dd-mmm-yy.
Any help would be excellant
Rgds