Hi,
it's the first time that I try to program a userforum and I have problems with coding my multilist.
I have a list with three columns and I have the possibility to choose several rows from the list.
For example:
Apple 1kg 1eur
Pear 1kg 2eur
Grapes 500g 2eur
...
Now I want to insert only the names of the fruits into my excel sheet (no weight and price), but in specific columns. So if I selected for example apple and grapes I want to insert apples in A1 and the second selected item (here grapes) in D1, a selected third fruit in G1...
All ideas I find in other forum are so complex and I feel, it must be really easy with something like
If Fruitlist.selected (Item) = True then
Range ("A1") = Fruit1
Range ("D1") = Fruit2
But I don't know how to define the Fruit1/2... and also how to make it independent from the amount of selected items, so that it works with no selected fruits (just empty) till many (icolumns + 3)
Has somebody a starting point for me?
Thanks in advance
Moni
Bookmarks