Hey Guys,
I have 2 listboxes : The first one is populated with everything i need from the worksheet.
The second listbox is for the user to see what items did he selected in order to be "transfered."
The problem that i face :
1)I can't move all data available on different columns, except the 1st one that contains the row id.
There are 4 options :
- move all to list 2 (button sign >>)
- move selected to list 2 (button sign >)
- move selected to list 1 (button sign <)
- move all back to list 1 (button sign <<)
Note when the user selects an item from list 1 and wants it to move to list 2 he must input a number that will appear in the last column (input box) -> done
2) When the user would transfer them back, the last column should not be...transfered. (related to the first one)
3) There is a button "info about selected" that should display everything from all the columns selected , but if nothing is selected, should display a message like "nothing selected" -> this results in an error. Works for listview , but not for listboxes ?
Side questions :
- (for easy noting 3.1)The button from the problem 3 can auto detect witch list is selected and the unselect the item after displaying the infos? or should i try 2 buttons for 2 listboxes ?
- (for easy noting 3.2) Mini-Bug? if using the second option - move selected to list 2 (button sign >) on the last item selected , the entire list is cleared . This does not happen if i select any other item from the list. It's something that i miss?
Thank you for your time and patience
I have attached a demo file and a picture with the code idea .
Bookmarks