IsDate

[Guest]

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?

 

[aidan.heritage]

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

 

[aidan.heritage]

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

 

[aidan.heritage]

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

 

[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.

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

 

[Guest]

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!!


"(e-mail address removed)" skrev:

 

[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?

 

[Guest]

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

"Norman Jones" skrev:

 

[Guest]

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.

 

[Guest]

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