Conditonal listbox
 

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...

Conditonal listbox
 

Give this a look...

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

Jim Thomlinson


" 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...