Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
start and end dates within listboxes
I have an interactive chart with four drop down list boxes. Two of these are
the Start Date and End Date. It all works fine. However I'm trying to restrict the user from selecting an End Date that is earlier than the Start Date. No luck as of yet. I want to eventually post this on a web page. thanks, casey |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
start and end dates within listboxes
Hi Casey,
Try Data Validation, Say your start date cell is D4 and end date cell is E4 Click in E4, go to DataValidationSettings Tab, select Custom from the dropdown box and set Formula is: =E4D4 Then click on the Error Alert tab and set the message you wish to appear. This will work fine in Excel, however, I know nothing about whether the functionality will hold when transferred to a web page. HTH Martin "casey" wrote in message ... I have an interactive chart with four drop down list boxes. Two of these are the Start Date and End Date. It all works fine. However I'm trying to restrict the user from selecting an End Date that is earlier than the Start Date. No luck as of yet. I want to eventually post this on a web page. thanks, casey |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
start and end dates within listboxes
Martin,
Thanks for your solution. That does work when those two cells are all I have. However, my dates (monthly) range for several years, from A2:A100. Again, thanks, casey "MartinW" wrote: Hi Casey, Try Data Validation, Say your start date cell is D4 and end date cell is E4 Click in E4, go to DataValidationSettings Tab, select Custom from the dropdown box and set Formula is: =E4D4 Then click on the Error Alert tab and set the message you wish to appear. This will work fine in Excel, however, I know nothing about whether the functionality will hold when transferred to a web page. HTH Martin "casey" wrote in message ... I have an interactive chart with four drop down list boxes. Two of these are the Start Date and End Date. It all works fine. However I'm trying to restrict the user from selecting an End Date that is earlier than the Start Date. No luck as of yet. I want to eventually post this on a web page. thanks, casey |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
start and end dates within listboxes
Hi Casey,
Just select the entire range before you apply the Data Validation the formula will update it's references down the column automatically. Make sure you select from top to bottom and not from bottom to top. HTH Martin "casey" wrote in message ... Martin, Thanks for your solution. That does work when those two cells are all I have. However, my dates (monthly) range for several years, from A2:A100. Again, thanks, casey "MartinW" wrote: Hi Casey, Try Data Validation, Say your start date cell is D4 and end date cell is E4 Click in E4, go to DataValidationSettings Tab, select Custom from the dropdown box and set Formula is: =E4D4 Then click on the Error Alert tab and set the message you wish to appear. This will work fine in Excel, however, I know nothing about whether the functionality will hold when transferred to a web page. HTH Martin "casey" wrote in message ... I have an interactive chart with four drop down list boxes. Two of these are the Start Date and End Date. It all works fine. However I'm trying to restrict the user from selecting an End Date that is earlier than the Start Date. No luck as of yet. I want to eventually post this on a web page. thanks, casey |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
start and end dates within listboxes
I don't think I've explained my situation well enough. Here I go. I may not
have even set it up in a way to allow me to use your solution. I have one drop down list for Start Date I have a second drop down list for End Date They both have the same Input Range of A2:A100 The Cell Link for the Start Date is C2 (The number of month in the list, i.e. if A2=Jan-00 (month #1), so if the Start Date was Jan-01, then C2=13) The Cell Link for the End Date is D2 (Same here. If The End Date was Dec-01, then D2=24) I've tried applying the Data Validation in various ways and still cannot make it work. Does this help explain it better? thnx again, casey "MartinW" wrote: Hi Casey, Just select the entire range before you apply the Data Validation the formula will update it's references down the column automatically. Make sure you select from top to bottom and not from bottom to top. HTH Martin "casey" wrote in message ... Martin, Thanks for your solution. That does work when those two cells are all I have. However, my dates (monthly) range for several years, from A2:A100. Again, thanks, casey "MartinW" wrote: Hi Casey, Try Data Validation, Say your start date cell is D4 and end date cell is E4 Click in E4, go to DataValidationSettings Tab, select Custom from the dropdown box and set Formula is: =E4D4 Then click on the Error Alert tab and set the message you wish to appear. This will work fine in Excel, however, I know nothing about whether the functionality will hold when transferred to a web page. HTH Martin "casey" wrote in message ... I have an interactive chart with four drop down list boxes. Two of these are the Start Date and End Date. It all works fine. However I'm trying to restrict the user from selecting an End Date that is earlier than the Start Date. No luck as of yet. I want to eventually post this on a web page. thanks, casey |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transferring items between multicolumn listboxes | Excel Discussion (Misc queries) | |||
start finish dates | Excel Discussion (Misc queries) | |||
Chart Start and End Dates ~ | Charts and Charting in Excel | |||
dates start at 01 January 1900 | Charts and Charting in Excel | |||
How do I refresh the selection listboxes on a pivot table? | Excel Discussion (Misc queries) |