PDA

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.
Cheers
John