Hello.
In Cell A1 I have a dropdown list (created via data validation), with values: ID,DATE,SEC_TYPE.
In cell A2, I want to display another dropdown list (with date values) when 'DATE' is selected in first drop down list.
If any other item is selected in first drop down list, allow any value in cell A2.
How can I do that?
Here is a sample using macros.
Gary's Student
Thanks!
2 questions:
1)What is the purpose of the line
2)is it possible to avoid of hardcoding the date items in the code (Macro1())? WE already have the dates in data validation of the cell.
Please Login or Register to view this content.
The macro responds to changes to any cell in the worksheet, we want it to pay attention to only A1.
To avoid hard-coding dates, we usually point the data validation to a list of cells. Where is your list??
my list is another sheet
That is cool.
I have never gotten DV to work off a list on a different sheet.
what do you mean?
You just select 'List' in data validation, and choose the data in different sheet....
List is in the same sheet, it's data in different sheet.
O.K.
Here is a version that uses a date list from another sheet (thanks to dredwolf).
thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks