Solved: More than 1 Validation in Single cell

[anandbohra]

hi friends
anybody can pl help me in inserting more than 2 validation in single cell.

I have data of last 10 years
to simplyfy viewing data in the chart i made 1 defined name as data_link which contains all date value of 10 years.
now i am allowing user to select start data from range A1 & end date from range A2.
right now both have validation as link - value (Data_link)
I want that user can not select End date less than start date value.

e.g. if user select in Start date i.e. A1 - 01/01/2007 after that in A2 he should select value more than 01/01/2007.

pl help me in this validation.

[daniel_d_n_r]

Is this code?
Possibly post some of your code, if I cannot give you the answer I am sure somone will if they can see an example of the code.

[anandbohra]

in this file there r 2 chart
in first chart u can change the series by clicking scroll bar
in second chart user can put his own start date & end date to get chart series
so i want end date should be more than start date

[Bob Phillips]

.

[anandbohra]

thanks XLD

:bow::bow::bow::bow::bow::bow::bow:

[c19h28O2]

Private Sub Worksheet_Change(ByVal Target As Range)
If Sheet10.Range("G42").Value = "" Then
Exit Sub
ElseIf Sheet10.Range("G42").Value <= Sheet10.Range("G41").Value Then
MsgBox "End Date should not be less than or equal to the start date..."
Sheet10.Range("G42").Value = ""
End If
End Sub



Doesn't need to do any calculation....

[anandbohra]

hi c19h28O2

the given code runs at your end???

coz i can not see any changes in workbook
as it wont prompt for deleting end date value
or even for typing value less than start date

will u pl upload the excel file where u had tested this code
your reply with attachment will be highly appreciated :clap::clap:
as u had pointed out good point as now it takes time to recalculate sheet:yes:yes

[c19h28O2]

Hi,

Sure....

Let me know how you get on....

[Bob Phillips]

Here's a version with fewer recalculations

[anandbohra]

hi xld & c19h28O2

both of you will u pl upload xls file coz i am trying to download attachement since last 15 minutes but it download attachment.php file


pl upload excel file & if it is big pl send me at my personal id
bohra_anand@yahoo.co.in

[Bob Phillips]

http://cjoint.com/?hznByxFoGc

[anandbohra]

Thanks XLD

u r simply genius

:bow::bow::bow::bow::bow:

and thanks c19h28O2 :friends::friends:
u might also have done best to solve my query but as i said still i am not able to download zip files from vbaexpress.com as it gives me attachment.php file instead of zip files


:beerchug: