Textbox Date value max

Solved/Closed
Chakresh - Jul 28, 2010 at 05:40 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Aug 18, 2010 at 05:18 AM
Hello,

My english is not good so sorry in advance

need to get the maximum and minimum value of date in excel userform .

i m use these code

If cbosex.Text = "Male" And cbocastcategory.Text = "General" And cboCategoryinwhichapplied = "General" And txtdob.Value >= 31 / 12 / 1987 And txtdob.Value <= 1 / 1 / 1991 Then
ActiveCell.Offset(0, 30).Value = "Uneligible in Date of Birth"
can any one help

from
Chakresh

2 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Jul 28, 2010 at 06:01 PM
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 and 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
2
hallo
rizvisa1
i am sending a sample on speedyshare.com please check it.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Jul 30, 2010 at 07:43 AM
you need to post the link here.
0
here where
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Aug 4, 2010 at 08:07 AM
what is the url is what I am asking
0
Sorry
i have 6 text boxes and i want this
if textbox1.value=a ,textbox2.value=a,textbox3.value=103,textbox4.value=120,textbox5.text=Yes, textboxdateofbirth between >01/01/1988 to <01/01/1991 then ActiveCell.Offset().Value = "Eligible"

textbox1.value=a ,textbox2.value=b,textbox3.value=99,textbox4.value=110,textbox5.text=No, textboxdateofbirth terminal <01/01/1988 to >01/01/1991 then ActiveCell.Offset().Value = "Uneligible"

please help me
0
thnx rizvisa1
1