Hi All,
So I've been stuck on this for a long time and will hugely appreciate any help given.
Basically:
I have a Userform with 6 List Boxes on it.
Let's call them:
Group1
Group2
Group3
Group4
Group5 and
TempGroup
Each Group (1-5) is populated with a 2 column list from range on the spreadsheet.
TempGroup is empty to start and will act as a holding box.
I have a button next to each Group(1-5) and then 5 x numbered buttons next to the TempGroup listbox.
The idea is this...
The user can select any item in a Group listbox, and click the button next to the lsitbox which will transfer the 2 column row into the TempGroup listbox.
They can then click the appropriate numbered button, eg. Button 2, and transfer that 2 column row back into Group 2 listbox.
What's more.....(sorry)
The first column of data is a product name, the second column is a price.
It would be good if each list box could have a label that keeps subtotal of the prices of items currently in that Group list box (changes as items are moved between Groups via the TempGroup).
Once the user is happy with Group setup a button will allow that configuration of lists to be put into a spreadsheet.
I did contemplate drag and drop but that killed my brain so would settle for the button approach as described but cant even get that working....
So I've been stuck on this for a long time and will hugely appreciate any help given.
Basically:
I have a Userform with 6 List Boxes on it.
Let's call them:
Group1
Group2
Group3
Group4
Group5 and
TempGroup
Each Group (1-5) is populated with a 2 column list from range on the spreadsheet.
TempGroup is empty to start and will act as a holding box.
I have a button next to each Group(1-5) and then 5 x numbered buttons next to the TempGroup listbox.
The idea is this...
The user can select any item in a Group listbox, and click the button next to the lsitbox which will transfer the 2 column row into the TempGroup listbox.
They can then click the appropriate numbered button, eg. Button 2, and transfer that 2 column row back into Group 2 listbox.
What's more.....(sorry)
The first column of data is a product name, the second column is a price.
It would be good if each list box could have a label that keeps subtotal of the prices of items currently in that Group list box (changes as items are moved between Groups via the TempGroup).
Once the user is happy with Group setup a button will allow that configuration of lists to be put into a spreadsheet.
I did contemplate drag and drop but that killed my brain so would settle for the button approach as described but cant even get that working....
