| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditonal Format | Excel Discussion (Misc queries) | |||
| Conditonal lay-out | Excel Worksheet Functions | |||
| conditonal formatting in VB | Excel Worksheet Functions | |||
| Conditonal Formatting | Excel Discussion (Misc queries) | |||
| listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
Hybrid Mode
