[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.excel.programming

Drop-down list dependant on another cell value

samdev

12/15/2006 5:09:00 AM

I want to create a drop-down list (using Data, Validation, selecting
List...) but the drop--down list that opens will be dependant on the
value of another cell.

For example:

In A1 the value "fruit" is entered and the drop-down list in B1 will
list fruit, but if "vegetable" is entered in A1 than a drop-down list
of vegetables will be displayed, if "meat" is entered in A1 then the
drop-down list will display a list of meat etc...

Right now there are 9 different options that could be entered in Column
A - this number may increase in the future. Each of these 9 options has
anywhere from 1 to 7 possibilities.

Any help would be appreciated. thx,
2 Answers

Martin Fishlock

12/15/2006 7:31:00 AM

0

Sam

Take a look at Debra Dalgleish's site http://www.contex...

She has a nice exampe at http://www.contex...xlDataVal02.html

Which also uses fresh produce (lol).

--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.


"samdev" wrote:

> I want to create a drop-down list (using Data, Validation, selecting
> List...) but the drop--down list that opens will be dependant on the
> value of another cell.
>
> For example:
>
> In A1 the value "fruit" is entered and the drop-down list in B1 will
> list fruit, but if "vegetable" is entered in A1 than a drop-down list
> of vegetables will be displayed, if "meat" is entered in A1 then the
> drop-down list will display a list of meat etc...
>
> Right now there are 9 different options that could be entered in Column
> A - this number may increase in the future. Each of these 9 options has
> anywhere from 1 to 7 possibilities.
>
> Any help would be appreciated. thx,
>
>

samdev

12/15/2006 4:42:00 PM

0

Perfect - exactly what I'm looking for - thx!! Have a great weekend!

Martin Fishlock wrote:
> Sam
>
> Take a look at Debra Dalgleish's site http://www.contex...
>
> She has a nice exampe at http://www.contex...xlDataVal02.html
>
> Which also uses fresh produce (lol).
>
> --
> Hope this helps
> Martin Fishlock
> Please do not forget to rate this reply.
>
>
> "samdev" wrote:
>
> > I want to create a drop-down list (using Data, Validation, selecting
> > List...) but the drop--down list that opens will be dependant on the
> > value of another cell.
> >
> > For example:
> >
> > In A1 the value "fruit" is entered and the drop-down list in B1 will
> > list fruit, but if "vegetable" is entered in A1 than a drop-down list
> > of vegetables will be displayed, if "meat" is entered in A1 then the
> > drop-down list will display a list of meat etc...
> >
> > Right now there are 9 different options that could be entered in Column
> > A - this number may increase in the future. Each of these 9 options has
> > anywhere from 1 to 7 possibilities.
> >
> > Any help would be appreciated. thx,
> >
> >