Multi-select list box

  • Thread starter Thread starter Scott
  • Start date Start date
S

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
 
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
Click to expand...
 
Back
Top