| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Combo Boxes
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional Combo Boxes
On Sep 27, 3:16 pm, PJFry 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional Combo Boxes
That page did the trick.
Thanks! "Leith Ross" wrote: On Sep 27, 3:16 pm, PJFry 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting Combo boxes to change options based on other Combo boxes. | New Users to Excel | |||
| Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
| Questions on combo boxes and list boxes. | New Users to Excel | |||
| Filtered list for Combo Box ListFillRange - Nested Combo Boxes | Excel Programming | |||
| Combo Boxes and Tick Boxes | Excel Programming | |||
Linear Mode
