View Full Version : Solved: More than 1 Validation in Single cell
anandbohra
07-24-2007, 10:13 PM
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
07-24-2007, 11:56 PM
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
07-25-2007, 12:02 AM
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
07-25-2007, 01:29 AM
.
anandbohra
07-25-2007, 01:42 AM
thanks XLD
:bow::bow::bow::bow::bow::bow::bow:
c19h28O2
07-25-2007, 01:53 AM
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
07-25-2007, 02:36 AM
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
07-25-2007, 02:49 AM
Hi,
Sure....
Let me know how you get on....
Bob Phillips
07-25-2007, 02:52 AM
Here's a version with fewer recalculations
anandbohra
07-25-2007, 03:50 AM
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
07-25-2007, 04:27 AM
http://cjoint.com/?hznByxFoGc
anandbohra
07-25-2007, 04:34 AM
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:
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.