Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
(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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ListBox1. add item myCell.entirerow | Excel Discussion (Misc queries) | |||
UserForm:Resume to ListBox1 | Excel Discussion (Misc queries) | |||
additem to combobox with an array | Excel Discussion (Misc queries) | |||
Help with: ListBox1.AddItem (ws.Name) | Excel Worksheet Functions | |||
additem to listbox built on the fly | Excel Programming |