Thread: Date...
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Libby again Libby again is offline
external usenet poster
 
Posts: 1
Default Date...

Hi again

With regard to my earlier reply, you need to say

If IsDate(Example) = true

Libby

-----Original Message-----
I heve got variable with name Example, its text. I use

this varible for
entry date.
Then I used: ExampleTrue = DateValue(Example) for

getting true date. When
Example is = 5/7/03 then ExampleTrue = 5.7.2003, but when

Example is only
=5/ its Error. So how can I checked if Example is good

entry: dd.mm.yy

Tom


.