Drop down boxes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pasty - 27 Oct 2006 09:10 GMT

Is there a way of having it so if people select on option on a drop down list
it will only let them edit a certain drop down box later in the sheet? e.g.
If the select project risks the can only edit the drop down boxes relevant to
them and same for bottom up risks etc.

Reply to this Message

Otto Moehrbach - 27 Oct 2006 19:19 GMT

Pasty
There's a couple of ways you can do that, both of which involve VBA.
One way is to have the VBA code lock those particular cells and/or
unlock the ones to which you want to retain access, then protect the sheet.
The other way is to have the code pop up a message box telling the user
that the particular cell is not available, then clear any selection made in
those cells.
Post back if this sound like what you want. HTH Otto

> Is there a way of having it so if people select on option on a drop down
> list
[quoted text clipped - 3 lines]
> to
> them and same for bottom up risks etc.

Reply to this Message

Pasty - 30 Oct 2006 13:46 GMT

What I am basically after is something like this:

Risk    Probability    Impact
BUR    BU1    BUI1
TDR    TD4    TDI1
TDR    TD2    TDI2
TDR    TD3    TDI5
BUR    BU4    BU5

Each of these TDR, BUR, PR & GRP will feed into their own seperate look up
tables to get certain results dependent on their probability and risks.

> Pasty
> There's a couple of ways you can do that, both of which involve VBA.
[quoted text clipped - 11 lines]
> > to
> > them and same for bottom up risks etc.

Reply to this Message

Debra Dalgleish - 28 Oct 2006 03:38 GMT

You might be able to use dependent data validation, with the dependent
cells showing only an option of "N/A" unless a specific option is selected.

There's information here:

http://www.contextures.com/xlDataVal02.html

> Is there a way of having it so if people select on option on a drop down list
> it will only let them edit a certain drop down box later in the sheet? e.g.
> If the select project risks the can only edit the drop down boxes relevant to
> them and same for bottom up risks etc.

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message

Pasty - 30 Oct 2006 13:41 GMT

This did work but then it occured to me that I could only have a section for
impacts or probabilitys relating to these and I need to have both coz I am
going to be linking it all up to seperate lookup tables dependent on their
outcome

> You might be able to use dependent data validation, with the dependent
> cells showing only an option of "N/A" unless a specific option is selected.
[quoted text clipped - 7 lines]
> > If the select project risks the can only edit the drop down boxes relevant to
> > them and same for bottom up risks etc.

Reply to this Message