(Worksheet)Listbox1.additem = (Form)Listbox1.value ??
 

How did you fill the listbox?

ActiveSheet.OleObjects("Listbox1").ListFillRange =
Userform1.Listbox1.RowSource

or
ActiveSheet.OleObjects("Listbox1").Object.List = Userform1.Listbox1.List

are some possibilities.

--
Regards,
Tom Ogilvy


"tj" wrote in message
om...
How can I transfer the items in a listbox that I created on a form to
a listbox that I have created on the worksheet?

Thurman