i have a listbox in a userform were some text is in ( titles of books )
sometimes this are 5 titles, sometimes 3 or 20.

now i need a code that when i push a button, the titles are being
copied to cells in a worksheet beginning from cel a1

and my problem is, i don't know the right code.

and its not:
range("sheet1!a1") = listbox.text
or .value

plz help me


--
tomro1
------------------------------------------------------------------------
tomro1's Profile: http://www.excelforum.com/member.php...o&userid=35081
View this thread: http://www.excelforum.com/showthread...hreadid=550708