Multi-select list box

[Scott]

Hi,

[Excel 2003] I was wondering if there is a way to put the results of a
multi-select list box into cells without using VBA. The single-select
list box returns the selected value to a cell, I was ideally hoping to
have some sort of list returned to a predefined range of cells. The
format really doesn't matter as long as it ends up in cells.

The other option I've used before was to have a bunch of check boxes,
but the list boxes are in general easier to work with -- thus the
question.

(Specifics to either better illustrate or confuse: Users need to
select a set of plants (from up to 15) [Multi-select list box]. This
is used to filter customer item data to sum it by the selected
plants. There is also a dropdown to select which customer they want
to highlight in the data. The end result is a scatterplot of the
margins on each product for the top 25 customers for the plants chosen
with one customer's sales highlighted.)

Thanks,
Scott

 

[Dave Peterson]

You'll need VBA.

But it's never bothered me to put a button/commandbutton next to the listbox
that the user clicks when he/she is done with selecting.

Hi,

[Excel 2003] I was wondering if there is a way to put the results of a
multi-select list box into cells without using VBA. The single-select
list box returns the selected value to a cell, I was ideally hoping to
have some sort of list returned to a predefined range of cells. The
format really doesn't matter as long as it ends up in cells.

The other option I've used before was to have a bunch of check boxes,
but the list boxes are in general easier to work with -- thus the
question.

(Specifics to either better illustrate or confuse: Users need to
select a set of plants (from up to 15) [Multi-select list box]. This
is used to filter customer item data to sum it by the selected
plants. There is also a dropdown to select which customer they want
to highlight in the data. The end result is a scatterplot of the
margins on each product for the top 25 customers for the plants chosen
with one customer's sales highlighted.)

Thanks,
Scott