View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default (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