List box?

[EnergyEngineer]

Hi,

I have a list of items in a column. I would like to have a userform pop up with a list box (?) of all the items and I want to be able to select multiple items to perform an action on the row corresponding to the selected item.

I am thinking of other examples I have seen where there are two list boxes (?) and then arrow buttons between them. When you click the arrow the item moves from one list box to the other to see which have been selected.

I have never used list boxes before so if you have a link to some sample code that would be useful. Or if I should use another option please let me know.

Thanks for any insights,
~RUTH~

[Dean England]

Dependant Dropdowns may be what your looking for.

Take a look here.

http://www.contextures.com/xlDataVal13.html

and here.

http://www.contextures.com/xlDataVal02.html

Hope that's what you're looking for.

Dean

[EnergyEngineer]

Hi Dean,

Thanks for the neat post. I will try to use this sometime. Unfortunately it isn't what I am looking for. I am writing a macro and I have code to execute to the selected items. I really need a pop up window with list boxes.

Currently I am playing with listboxes. I have two one with the list of all the items and another with the list of the selected items. My code isn't working though. How do I add items to the .List() array?

~RUTH~

[Dean England]

Ruth,

Sorry, but I'm a bit of a VBA non-entity. However, I downloaded this from VBA Express a long time ago and it may give you some ideas from looking at the code.

Sorry, I can't be of more assistance.

Dean

[EnergyEngineer]

Thanks for the file Dean. Unfortunately they don't use the list box.

Does anyone know how to use multiselect listboxes? The below code works for a singleselect but not for multiselect. I know I am suppose to use .selected instead of .value but I am not sure how.

Thanks,
~RUTH~

Please Login or Register  to view this content.

[mikerickson]

Please Login or Register  to view this content.

[EnergyEngineer]

Hi Mike,

Thanks for your post. How do you get the value stored in listbox(i)? Currently this just gives the index # i. I would like the corresponding item name.

Thanks,
~RUTH~

[mikerickson]

Please Login or Register  to view this content.

returns the i'th item in the list.

Please Login or Register  to view this content.

will show all selected items.
Note that a userform's listbox's List is zero based. The first item in the list is

Please Login or Register  to view this content.

[EnergyEngineer]

Got it! Thank you so much for your help. Unfortunately I still have some bugs. I have two list boxes. And this is the code for when I want to add the selected items to the 2nd lb.

Please Login or Register  to view this content.

~RUTH~

[EnergyEngineer]

Ok I got it.

~RUTH~

Please Login or Register  to view this content.