View Full Version : Excel- date formats

09-01-2000, 09:21 PM
I'm using a userform taht requires user to put in dates as dd/mm/yy format. I use Isdate and Format to ensure dates are entered. It still accepts american dates such as 12/24/99 when it shouldnt. How do I make sure it doesnt accept such dates.
Also, how do i show one date thats entered by the user show up in text box later on on the same form at run time, so they dont need to enter this box.