I have had a request to build an Excel sheet with conditional combo boxes.
As I understand it, there are two combo boxes. If the user selects A in the
first once, the choices 1,2 and 3 are available in the second box. If they
choose B then 4,5 and 6 are available.

I do this in Access all the time, but I have never attempted it in Excel.
Is it possible?

Disclaimer: This project really belongs in a database environment, but only
a handful of people have Access and everyone has Excel.

On Sep 27, 3:16 pm, PJFry <PJ...@discussions.microsoft.com> wrote:
> I have had a request to build an Excel sheet with conditional combo boxes.
> As I understand it, there are two combo boxes. If the user selects A in the
> first once, the choices 1,2 and 3 are available in the second box. If they
> choose B then 4,5 and 6 are available.
>
> I do this in Access all the time, but I have never attempted it in Excel.
> Is it possible?
>
> Disclaimer: This project really belongs in a database environment, but only
> a handful of people have Access and everyone has Excel.

Hello PJFry,

Have a look at this sight for some ideas about how to use and setup
Combo Boxes or Drop Downs as they are sometimes called.
http://www.contextures.com/xlDataVal13.html

Sincerely,
Leith Ross

That page did the trick.

Thanks!

"Leith Ross" wrote:

> On Sep 27, 3:16 pm, PJFry <PJ...@discussions.microsoft.com> wrote:
> > I have had a request to build an Excel sheet with conditional combo boxes.
> > As I understand it, there are two combo boxes. If the user selects A in the
> > first once, the choices 1,2 and 3 are available in the second box. If they
> > choose B then 4,5 and 6 are available.
> >
> > I do this in Access all the time, but I have never attempted it in Excel.
> > Is it possible?
> >
> > Disclaimer: This project really belongs in a database environment, but only
> > a handful of people have Access and everyone has Excel.
>
> Hello PJFry,
>
> Have a look at this sight for some ideas about how to use and setup
> Combo Boxes or Drop Downs as they are sometimes called.
> http://www.contextures.com/xlDataVal13.html
>
> Sincerely,
> Leith Ross
>
>