Print items from a listbox

[rcprito]

hey everyone.

I want to print all the items I have in a listbox, but it's not working.

palete.png

As you can see I have 4 items in this example , but when I try to pass them to my file, it only goes the first item.

I was writing this

Imprimir3.Cells(7, 3) = ListBox1.List

but it doesn't seems to work.

Thanks in advance!

[rcprito]

can anyone help me?

[thameem127]

Upload a file same as attached png. I can solve it.

[rcprito]

I can't upload only that file, because then it's not going to work. And I cannot send you all the programm.

But, If you want, I can send you only that userform with the code in it.

I just want that the items in the listbox appear in that file to get printed..

[Norie]

This will only put one value in C7 on Imprimir3.

Imprimir3.Cells(7, 3) = ListBox1.List

If you want to put all the values from the listbox on the sheet you'll either need to resize the destination range or use a loop.