ajm
04-03-2008, 07:11 PM
I have a series of milestone descriptions held in named ranges depending upon the type of project to which they belong. Currently, my users can select any milestone in the validation list for that project type. THis means that they could inadvertantly go backwards if they select incorrectly. The formula in the cell validation for my column is:
"=INDIRECT(SUBSTITUTE(I11," ",""))" with the project type in Column I.
I am after a VBA solution that will not show preceding milestones when the change is made to a new milestone.
as an example, say MS1, MS2, and MS3. When selecting MS1, the user can also see MS2 and MS3. HOwever, once MS1 is selected, when they next use the dropdown to move forward to MS2, I don't want them to be able to see MS1. By the way, my milestones are not numeric and are not in alphabetic order.
Any suggestions?
"=INDIRECT(SUBSTITUTE(I11," ",""))" with the project type in Column I.
I am after a VBA solution that will not show preceding milestones when the change is made to a new milestone.
as an example, say MS1, MS2, and MS3. When selecting MS1, the user can also see MS2 and MS3. HOwever, once MS1 is selected, when they next use the dropdown to move forward to MS2, I don't want them to be able to see MS1. By the way, my milestones are not numeric and are not in alphabetic order.
Any suggestions?