I am trying figure out a way to make a series of list boxes
conditional.

for example:

Cell a1: list box
not started, started

Cell b1: a percentage
can be any number 0-100

Cell c1: list box
please select, ready for review, review complete




i dont want someone to be able to select ready for review from the
list in cell c1 unless b1 = 100

how would i go about doing this....

where would i put the code...

not good at this stuff so all help is appreciated...

Give this a look...

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

Jim Thomlinson


"(E-Mail Removed)" wrote:

> I am trying figure out a way to make a series of list boxes
> conditional.
>
> for example:
>
> Cell a1: list box
> not started, started
>
> Cell b1: a percentage
> can be any number 0-100
>
> Cell c1: list box
> please select, ready for review, review complete
>
>
>
>
> i dont want someone to be able to select ready for review from the
> list in cell c1 unless b1 = 100
>
> how would i go about doing this....
>
> where would i put the code...
>
> not good at this stuff so all help is appreciated...
>