UserForm listbox transfer to excel and save

Fermé
trevsiob Messages postés 7 Date d'inscription jeudi 7 août 2014 Statut Membre Dernière intervention 8 août 2014 - 7 août 2014 à 13:19
pijaku Messages postés 12263 Date d'inscription jeudi 15 mai 2008 Statut Modérateur Dernière intervention 4 janvier 2024 - 8 août 2014 à 13:20
Hi,
I'm new to this forum and certainly new to VBA. I have a UserForm with 4 listbox. The users select items from the first listbox, they press an "add" button and the selection is sent to the 2nd listbox. They can select an item they sent in the 2nd listbox and press "remove" to delete the item from the second listbox (for example if they selected an item by mistake). They do the same thing with the 3rd listbox where is another list of item they have to choose and sent into the 4th listbox. Finally they press a "complete" button and all the data from listbox 2 and 4 is sent into 2 listbox on an excel worksheet. on the worksheet I also have a modify button for users to reopen the userform with the current selection and modify it. This process works fine but I have 2 problems. First, I want to be able to save the data on the worksheet and modify it when the worksheet is reopen. Currently, I send the data into a cell range so the selection can be saved and I wrote a code in the WorkSheet_Open where my 2 listbox on the worksheet are populate with the range. But when I reopen the file I can't modify the selection again. Second problem, I want that the users can't select an item twice in the userform. I would like that when an item is sent to the second listbox, it become enabled or invisible or deleted from the source listbox and when the remove button is press the item reappears in the source listbox.

Hope I'm clear enough!

Thank a lot!
Alex
A voir également:

3 réponses

WeaponEDGE Messages postés 113 Date d'inscription vendredi 18 juillet 2014 Statut Membre Dernière intervention 21 novembre 2014 9
Modifié par WeaponEDGE le 7/08/2014 à 15:55
Hi trevsiod,

Could you join your file?
use the website https://www.cjoint.com/ and copy the link in your next message.
0
trevsiob Messages postés 7 Date d'inscription jeudi 7 août 2014 Statut Membre Dernière intervention 8 août 2014
7 août 2014 à 16:37
I can't i'm working on this file at work and our network doesn't allow me to go on that website
0
skk201 Messages postés 938 Date d'inscription jeudi 11 septembre 2008 Statut Membre Dernière intervention 16 octobre 2016 54
7 août 2014 à 16:51
Try this web site : https://www.webtransfer.ch/en/start

and choose you as "Recipient's email address(es)"

Then share with us the link that you gonna recive.
0
trevsiob Messages postés 7 Date d'inscription jeudi 7 août 2014 Statut Membre Dernière intervention 8 août 2014
7 août 2014 à 16:58
Same thing here...untrusted site from my work's network!
0
trevsiob Messages postés 7 Date d'inscription jeudi 7 août 2014 Statut Membre Dernière intervention 8 août 2014
7 août 2014 à 17:20
Here it is I manage to transfer it!
http://www.webtransfer.ch/en/download/681f638314d6f969a10b6194ea81ea4238ea1d80
0
pijaku Messages postés 12263 Date d'inscription jeudi 15 mai 2008 Statut Modérateur Dernière intervention 4 janvier 2024 2 751
8 août 2014 à 08:14
Hi,

Sorry, but here is a French language forum.

If you want somme help about programming, we also have fora to do that in English.

If you want, you can continue Click here.

I have to close this subject.
0
pijaku Messages postés 12263 Date d'inscription jeudi 15 mai 2008 Statut Modérateur Dernière intervention 4 janvier 2024 2 751
8 août 2014 à 13:20
Bon,
La suite en français : ICI
0