Posted to microsoft.public.excel.programming

Luis Verme Luis Verme is offline

external usenet poster

Posts: 8

Validating Dates

I'm trying to validate dates whuen I make an input ("dd/mm/yy"). I use the
routine

If IsDate(txtFFinal) Then
MsgBox "Date is correct"
else
MsgBox "Date is correct"
End If

When I enter the date 31/06/2005 it assumes it's a correct date.

Any suggestions?

Thanks

Luis Verme

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
sumproduct - validating codes & dates	Chuck[_3_]	Excel Worksheet Functions	3	November 14th 07 01:12 AM
validating	Ayesha	Excel Worksheet Functions	2	April 26th 06 02:56 PM
Validating	Sdbenn90	Excel Discussion (Misc queries)	0	March 27th 06 12:05 AM
Validating Dates Entered	patam	Excel Discussion (Misc queries)	2	September 2nd 05 05:36 PM
Event validating two ranges with dates	G R E G	Excel Programming	1	August 9th 03 12:03 AM

All times are GMT +1. The time now is 09:55 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us