Userform with Listbox to lookup values in range - Spin Button Issue

Hi all,

I'm in need of some help with using listboxes and spinbutton to reorder in a listbox.

So there are three issues I'm having here and I'll list them in level of importance (the order I need most help with)

1) - I've never used spin buttons, however I want to be able to reorder the listbox values in listbox2. Listbox2 is currently populated from any of the options from listbox1 however I want to be able to reorder them once they've been moved over.

2) - When I add/remove from a listbox with the last value selected it moves the entire contents over to the other listbox. I want it to work like it does if you select a value which is not the last in the list.

3) - For a quick mock up I've used a different userform which only has a combobox to make a selection from. I have this coded to update in the file which is fine, however I'm not that confident with cycling through the whole list of items which will be in Listbox2. So any advice on this also would be greatly appreciated.

Thanks in advance.

Q1

I want to be able to reorder the listbox values in listbox2

How? What order do you want or do you mean you want to move the selected item up/down the list when clicked?

Q2
If an item is selected, then removing it will cause the ListBox to select the item above. Simple solution is unselect it before moving to the other listbox.

Please Login or Register  to view this content.

If the listbox is not going to be MultiSelect you can get away with referring to the ListIndex to copy/remove - that'll do away with the loop and make this issue go away as as consequence.

Q3

however I'm not that confident with cycling through the whole list of items which will be in Listbox2

But you cycle though the whole list of items in ListBox1. Can you expand on this?

Thanks Cytop

So Q1: Yes I want to reorder the items in Listbox2 by moving them up or down the list order

Q2: The listbox won't be multiselect, so the user will have to select one by one from listbox1 to move over to listbox2, and then the same to remove from listbox2 to listbox1

Q3: In userform1 I only have a combobox which once selected adds the column to right. However as I want to use the list of items to add extra columns in I don't know how to code it. So for combobox1 in userform1 I can simply use combobox1.value, however for Listbox2 I don't want to use the value selected, I want to add a new column in for every item in that listbox2. The cycling through items in ListBox1 is code I found online and used so my understanding of it is very low.

Thanks again

Q1

Something like this:

Please Login or Register  to view this content.

(Edit - code refers to ListBox1; you want ListBox2. Simple enough change)

Q2
If the listboxes are not multiselect then the Add code can be simplified:

Please Login or Register  to view this content.

Sorry - I don't understand Q3.

Q1 - Absolutely Nailed It! Thanks Cytop

Originally Posted by PFDave

3) - For a quick mock up I've used a different userform which only has a combobox to make a selection from. I have this coded to update in the file which is fine, however I'm not that confident with cycling through the whole list of items which will be in Listbox2. So any advice on this also would be greatly appreciated.

I've managed to resolve this myself now so thanks.

Just 2) still a concern

Originally Posted by cytop

Q1

Q2
If the listboxes are not multiselect then the Add code can be simplified:

Please Login or Register  to view this content.

Sorry - I don't understand Q3.

I've resolved 3 myself, that was the population of the sheet for each item in the listbox2.list.

Cytop you've saved me a chunk of time and increased my understanding. Thank you so much

Originally Posted by cytop

How is Q2 still a concern?

Didn't see your edited post. Thanks again, really appreciated

Originally Posted by cytop

My fault then - I tend to answer questions with multiple parts bit by bit... must get out of that habit.

Don't you ever change