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