Obviously there are hundreds of threads on the above subject but really i have not been able to find the correct answer and I myself have not been able to figure out the same...so thats why I am asking all you excel gurus to pl help me out
On a user form i have a textbox for accepting date. Earlier I had linked it to calendar but now the user does not want calendar but a direct input in the textbox whereupon clicking a commandbutton the date will get supplied to another code.
My problem is this
1...How do I make the textbox accept date only in the "dd/mm/yyyy" format
2....ensure that error message is displayed if there is departure from format (even though the date may otherwise be valid)
3....supply the date in "dd/mm/yyyy" format to the subsequent code
Thanx in advance