Hi I have two problems
1. In the first textbox of a userform I need a date to be entered. the format of this date has to be dd/mm/yy. How do I stop anyone from entering dates in any other format i.e. dd.mm.yy etc?
I had tried using a Combobox and validating the cells from a list in the spreadsheet, but when the selected date was chosen it changed it into numbers i.e. 16/02/04 became 30245 or something like this. Although when the info was dumped into the spreadsheet it reverted back, I don't want this to happen as it would confuse the user.
2. In two other textboxes I require times to be input a start time and a finish time which have to be entered as ##:## so that when the data is dumped into the spreadsheet I am using the formula to calculate the total time works.
Can anyone help me with the code to validate these boxes so that a message appears if the format is entered wrong and the data is deleted?
Thanks
Jo
1. In the first textbox of a userform I need a date to be entered. the format of this date has to be dd/mm/yy. How do I stop anyone from entering dates in any other format i.e. dd.mm.yy etc?
I had tried using a Combobox and validating the cells from a list in the spreadsheet, but when the selected date was chosen it changed it into numbers i.e. 16/02/04 became 30245 or something like this. Although when the info was dumped into the spreadsheet it reverted back, I don't want this to happen as it would confuse the user.
2. In two other textboxes I require times to be input a start time and a finish time which have to be entered as ##:## so that when the data is dumped into the spreadsheet I am using the formula to calculate the total time works.
Can anyone help me with the code to validate these boxes so that a message appears if the format is entered wrong and the data is deleted?
Thanks
Jo