Selectable list box

Hello all,

Can a list box (or other type) be created that would come up and allow a selection of multiple items. I do not need the items to be viewable beyond the selection, only to be ablle to sum different segments of the rows that were selected.

As example: Upon clicking in cell B 141 of the sheet a box would come up that would include the descriptions (in column C) of all items that are between rows 1 and 140 that have identifeid by a "y" in Column B. Then you could select as many as you desired and the sum of the quantity (column d) of the selected items would then appear in D141.

Would something like this be possible?

Thanks,
Mark

Set the .MultiSelect property of the list box to True.

Thanks for the reply, however I know nothing about the creation of a list box. Could you help with a little additional info?

Thanks,
Mark

Yes, but after I'm off work. (Your problem is more complicated than I thought. Poor time mgt on my part.)

Great!!! I look forward to it. This is a problem I have wanted solved for a long time. I have tried every way and failed.

Thanks,
Mark

I haven't abandoned the problem. I'm having trouble reading a multi-select forms list box. I think the way to go is:

When B141 is selected a userform is created. It has the list box you want and a cancel button and an OK button.

Select the items you want and the running total will be put into D141.

Press Cancel, everything disapears and the old value is restored.
Press OK, userform goes away, leaving the new sum in D141.

Selecting a different cell when the userform is present is the same as pressing OK.

What version do you have, (i.e. is it '97 with only modeless uForms?)

It is working now -- Thank you very much.

mark medlin