Multiple Parameter drop down

[Pofski]

Hi everybody,

I was wondering if it was possible to make a drop down that is semi automatic, but still manually changeable.

for example, you have a drop down list in B1, When you fill in something in A1, it automatically changes to "Started" (for example), you can still manually change it to "In process", and it will stay that way.
But if today is past a certain due date, it would again change to "Overdue"

I hope this makes some sense.

Thank you all in advance

 

[NARAYANK991]

Hi Pofski ,

More details please !

1. There is a drop-down in B1 ; what are the items in the drop-down , text , numeric , what is the source data .... ?

2. When A1 is filled with something "it automatically changes to "Started" ; by it , I assume you mean B1 ?

3. If the current date is past some threshold date , it changes to Overdue ?

Basically , I understand that B1 can take one of several values viz. Started , In process , Overdue ,.... ; for at least 2 of these , it is logic which will decide the result.

I think what you want can only be done using VBA ; is this acceptable ?

Narayan

 

[Pofski]

Hi Narayan,

i prefer to avoid VBA where possible, but if this would be the best solution, then there is no choice.
I included a small example file.
the only thing that really has to be taken into account, is the fact that the available statuses can change (grow or shrink), and the files always have to be made with possible changes in the future in mind (i usually use the offset formula to make a named dynamic range for this)

Concerning the overdue i was thinking about using the =today()>C3 for true/false statement, and maybe using that in a formula.

Sincerely

 

[NARAYANK991]

Hi Pofski ,

I do not know whether VBA is the only way to get what you want ; can you check your file now ?

In case anyone else downloads the file , and comes up with a formula solution to do exactly what the VBA code does , that will be nice.

Narayan