I am simplifying this post (and the attached file) from my earlier post in hopes of getting some help. I have been pounding my head against the wall for days on this, still can't get it to work.
I modified some code from another person's post to try to achieve what I was looking to do:
http://www.excelforum.com/excel-form...selection.html
I have a table, there are multiple columns.
I have two columns [Category] & [Detail], each of them has a drop down list.
The values displayed in the drop down for [Detail] are dependent on what was chosen from the drop down in [Category].
I have used the INDIRECT function to properly display the right list of values in the [Detail] column.
I have a value in [Category], "Mineral" for which I do not want the drop down to appear in [Detail], all other values should activate the drop down list in [Detail] and invoke the INDIRECT function.
I was able to use the code from the other post to get the dropdown suppressed in the first row of my table, and to get the INDIRECT call working for the valid values. (Please note this worksheet will eventually be protected, in order to get the INDIRECT call portion of the macro to work I had to "unlock" the cell first - via the macro)
Can't figure out how to get it to work on the rest of the rows in the table (which can vary depending on if the user is adding or deleting rows).
Including the code as I have modified it to work. E6 is the location of first row [Category], F6 is the location of first row [Detail]
Also note, including the code which clears the info in [Detail] should the value of [Category] change.
I am attaching a sample file.Please Login or Register to view this content.
The password to unprotect, is "orderform"
thanks!
Bookmarks