Textbox Date value max

Solved/Closed
Chakresh - 28 Jul 2010 à 05:40
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 18 Aug 2010 à 05:18
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
Related:

2 responses

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
28 Jul 2010 à 18:01
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
hallo
rizvisa1
i am sending a sample on speedyshare.com please check it.
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
30 Jul 2010 à 07:43
you need to post the link here.
here where
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
4 Aug 2010 à 08:07
what is the url is what I am asking
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
thnx rizvisa1