IsDate

[april27]

I am writing a macro for an Excel spreadsheet. in a user form i have a text
field. in this field the user shall enter a date. the program shall then
revise the date and return an error message if it is not a date. I try to use
the IsDate function but i dont know how to use it and my help menu does not
give me any info on this. anyone?

[[email protected]]

if(not(isdate(TextBoxName.text))) then
msgbox "You have not entered a valid date - please retry
cancel=true
end if

this would go in the exit event of the text box
april27 wrote:
> I am writing a macro for an Excel spreadsheet. in a user form i have a text
> field. in this field the user shall enter a date. the program shall then
> revise the date and return an error message if it is not a date. I try to use
> the IsDate function but i dont know how to use it and my help menu does not
> give me any info on this. anyone?

[[email protected]]

if(not(isdate(TextBoxName.text))) then
msgbox "You have not entered a valid date - please retry
cancel=true
end if

this would go in the exit event of the text box
april27 wrote:
> I am writing a macro for an Excel spreadsheet. in a user form i have a text
> field. in this field the user shall enter a date. the program shall then
> revise the date and return an error message if it is not a date. I try to use
> the IsDate function but i dont know how to use it and my help menu does not
> give me any info on this. anyone?

[[email protected]]

if(not(isdate(TextBoxName.text))) then
msgbox "You have not entered a valid date - please retry
cancel=true
end if

this would go in the exit event of the text box
april27 wrote:
> I am writing a macro for an Excel spreadsheet. in a user form i have a text
> field. in this field the user shall enter a date. the program shall then
> revise the date and return an error message if it is not a date. I try to use
> the IsDate function but i dont know how to use it and my help menu does not
> give me any info on this. anyone?

[Norman Jones]

Hi Apil27,

Copied direct from VBA help

'===================>>:

IsDate Function

Returns a Boolean value indicating whether an expression can be converted to
a date.

Syntax

IsDate(expression)

The required expression argument is a Variant containing a date expression
or string expression recognizable as a date or time.

Remarks

IsDate returns True if the expression is a date or is recognizable as a
valid date; otherwise, it returns False. In Microsoft Windows, the range of
valid dates is January 1, 100 A.D. through December 31, 9999 A.D.; the
ranges vary among operating systems.


IsDate Function Example
This example uses the IsDate function to determine if an expression can be
converted to a date.

Dim MyDate, YourDate, NoDate, MyCheck
MyDate = "February 12, 1969": YourDate = #2/12/69#: NoDate = "Hello"
MyCheck = IsDate(MyDate) ' Returns True.
MyCheck = IsDate(YourDate) ' Returns True.
MyCheck = IsDate(NoDate) ' Returns False.

'<<===================


---
Regards,
Norman



"april27" <[email protected]> wrote in message
news:[email protected]...
>I am writing a macro for an Excel spreadsheet. in a user form i have a text
> field. in this field the user shall enter a date. the program shall then
> revise the date and return an error message if it is not a date. I try to
> use
> the IsDate function but i dont know how to use it and my help menu does
> not
> give me any info on this. anyone?

[april27]

thanks. but what is a valid date? although I type a correct date (i think)
e.g. 20060612 the program sends me error message. do you know´how to solve
the problem or write the date in proper form? Very thankful for fast
assistance!!


"[email protected]" skrev:

> if(not(isdate(TextBoxName.text))) then
> msgbox "You have not entered a valid date - please retry
> cancel=true
> end if
>
> this would go in the exit event of the text box
> april27 wrote:
> > I am writing a macro for an Excel spreadsheet. in a user form i have a text
> > field. in this field the user shall enter a date. the program shall then
> > revise the date and return an error message if it is not a date. I try to use
> > the IsDate function but i dont know how to use it and my help menu does not
> > give me any info on this. anyone?
>
>

[Norman Jones]

Hi April27,

>I am writing a macro for an Excel spreadsheet. in a user form i have a text
> field. in this field the user shall enter a date. the program shall then
> revise the date and return an error message if it is not a date. I try to
> use
> the IsDate function but i dont know how to use it and my help menu does
> not
> give me any info on this. anyone?

Why not use a calendar control for date entry?


---
Regards,
Norman?

[april27]

yes that would be nice but I dont know how to do it. any clue? :-)

"Norman Jones" skrev:

> Hi April27,
>
> >I am writing a macro for an Excel spreadsheet. in a user form i have a text
> > field. in this field the user shall enter a date. the program shall then
> > revise the date and return an error message if it is not a date. I try to
> > use
> > the IsDate function but i dont know how to use it and my help menu does
> > not
> > give me any info on this. anyone?
>
> Why not use a calendar control for date entry?
>
>
> ---
> Regards,
> Norman?
>
>
>

[Tom Ogilvy]

Excel won't recognize that as a valid date because it can not diffentiate
that from the number 20,060,612. A good test to see what is accepted as a
date is to enter it in a cell in the worksheet and see if it is
displayed/stored as the date you intended.

If you want to use that format, then you can't use IsDate. You will have to
write all the code to determine if what is entered is a valid date.

--
Regards,
Tom Ogilvy


"april27" wrote:

> thanks. but what is a valid date? although I type a correct date (i think)
> e.g. 20060612 the program sends me error message. do you know´how to solve
> the problem or write the date in proper form? Very thankful for fast
> assistance!!
>
>
> "[email protected]" skrev:
>
> > if(not(isdate(TextBoxName.text))) then
> > msgbox "You have not entered a valid date - please retry
> > cancel=true
> > end if
> >
> > this would go in the exit event of the text box
> > april27 wrote:
> > > I am writing a macro for an Excel spreadsheet. in a user form i have a text
> > > field. in this field the user shall enter a date. the program shall then
> > > revise the date and return an error message if it is not a date. I try to use
> > > the IsDate function but i dont know how to use it and my help menu does not
> > > give me any info on this. anyone?
> >
> >

[Tom Ogilvy]

http://www.rondebruin.nl/calendar.htm

--
Regards,
Tom Ogilvy


"april27" wrote:

> yes that would be nice but I dont know how to do it. any clue? :-)
>
> "Norman Jones" skrev:
>
> > Hi April27,
> >
> > >I am writing a macro for an Excel spreadsheet. in a user form i have a text
> > > field. in this field the user shall enter a date. the program shall then
> > > revise the date and return an error message if it is not a date. I try to
> > > use
> > > the IsDate function but i dont know how to use it and my help menu does
> > > not
> > > give me any info on this. anyone?
> >
> > Why not use a calendar control for date entry?
> >
> >
> > ---
> > Regards,
> > Norman?
> >
> >
> >