Excel-erate2004 < wrote:

Hi all,

I'm not sure how to do this, but I believe it can be done.

How could I make more than 1 selection from a combo box then have those
selections appear on another sheet in the order that they were selected.
Would I need some kind of buffer or memory container?

For example:

I have 29 products, the user will choose from a combobox of a possible
29 items, then those selections (meaning more than just 1 selection)
will be sent to another sheet which will influence something else.

I hope I described my problem well enough.

Thanks

P.S. I am developing in Excel 2000 using VBA


---
Message posted from http://www.ExcelForum.com/



i would create an event for the list box using the onClick event or
something similar depending on what your programming in, and in the on
click event add the name of the selected object to an array, that will
add them in the order they are selected so that you can use your array
to add it to the other sheet.. does this help?