View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bob Umlas, Excel MVP Bob Umlas, Excel MVP is offline
external usenet poster
 
Posts: 320
Default Error Check Dates

IF ISDATE(me.Textbox1.Text) then...

but you may want to further check years, because you MIGHT have a year of
3081, so maybe
IF Isdate(me.textbox1.Text) then
IF Year(me.textbox1.text)2100 then 'arbitrary year here
MsgBox "Invalid Date"
etc.

"jlclyde" wrote:

I have a user form that I would like people to enter dates, I woudl
like to check to make sure that they are indeed dates. What is the
error checking for this? Could someone help with this?

Thanks,
Jay