Software

Ask something
Discussion Locked

Selecting options in Microsoft Excel

0 helpful
5 replies

by allsopda

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

In an Excel spreadsheet, there is a requirement to have a number of options available (say 4). Then alongside these are some list boxes which list the options available.
So, the example of 4 options the first list box will have all 4 options available. Then the next list box will have the three remaining options listed; and so on for the other list boxes.
Is there an easy way to implement this?

5 replies

by lo

Not too sure what you design goal is but ...

If there is something passed or available that will allow you to make the determination of 4, 3, 2, etc. you can populate a single list box (or multiple instances) using the value to load the choices.Something like:

IF = "OPTION4" THEN

ELSEIF = "OPTION3" THEN

ELSEIF = "OPTION2" THEN

etc.

You can use the same/similar with 4 controls and hide/disable all but the one desired.

lo

by james_randy

If you are still tackling this problem, perhaps you should consider calling your local super-hero.

This discussion is closed to new replies.