(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
|