Previous Topic Next Topic

Date ofbirth between 01/01/1995 to 01/01/2005

Solved/Closed
AKS - 19 Aug 2010 à 07:33
 AKS - 9 Sep 2010 à 03:41
Hello,

I have a userform with a text box name txtdob.
i m trying to do if i add a date in text box between 01/01/1995 to 01/01/2005 then msgbox show "Eligible" and sheet1 collumn A2 "Eligible"
and if date is Before 01/01/1995 then msgbox show " UnEligible " and sheet1 collumn A2" UnEligible " & After 01/01/2005 then msgbox show " Uneligible" and sheet1 collumn A2" UnEligible "
please help me

1 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
20 Aug 2010 à 08:50
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
A N D post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
23 Aug 2010 à 08:51
You can use this 


If ((Format(DATEOFBIRTH, "yyyymmdd") < "199500101") _
        Or (Format(DATEOFBIRTH, "yyyymmdd") > "200500101")) Then
        MsgBox ("Ineligible")
        
    Else
    
        MsgBox ("Eligible")
End if


Just a side note, it is "Ineligible" not "Uneligible" and you should spell "Temperory" as "Temporary"
AKS
25 Aug 2010 à 04:45
thanks it solve my problem
there is another problems i have piease solve it
1- how to set numeric value in text box.
2- in user form i have 02 text boxes with numeric value for example first text box have "81 cm " and second have text box "86 cm" it means in these text boxes i want minimum gap "6 cm" and if these text box have "81" or "85" msgbox Ineligible.
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
25 Aug 2010 à 08:27
for #1
you can test the value if it is numeric or not. The function is "IsNumeric"

for #2
"18 cm" is not numeric. "18" is. So if you have entered "18 cm", then its a text.
You can test if as DOB was tested. Only thing, in this case there does not seem to be any reason to format the numbers
AKS
27 Aug 2010 à 05:03
thnx it solve my problem
and no. 2 problem is i says 18 cm but it is only for example
i want if text box 2 text count text box 1 no +6 (any 1 to 999)
like if text box1 have 01 then text box2 count +6 if it is +6 then Ok
if text box1 have 10 then text box2 count +6 if it is +6 then Ok
if text box1 have 99 then text box2 count +6 if it is +6 then Ok and
if text box1 have 01 then text box2 count is not +6 if it is not +6 then False
any no. a add in text box1 then text box 2 count it +6 and give me OK or False

Similar discussions

Lastest Whastapp for Nokia X2-01
YvanRwanda -
Ambucias -

5 responses
Antivirus for nokia c1-01
Chinabull -
J.austinmohit -

2 responses
How can I login to 10.0.0.0.1 IP
kopollo -
martinxgarrix -

1 response
Nokia c2-01
Timothy Heu Min Tao -
Ambucias -

1 response
how to get wi-fi on my nokia x2
pablo sandoval -
Ambucias -

1 response