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