Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiselect Listbox
I have a listbox with with its properties set to mutliselect and is popupated
with "Apples, Oranges, Peaches, Grapes, Apricot and Guava. When the user select say, Oranges and Grapes, I want these to be displayed but do not know how to write the code. I have looked at previous postings but the responses only dealt with showing the listindex value instead of the actual description. Can someone help! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiselect Listbox
With Userform1
rw = 1 for i = 0 to .Listbox1.Listcount - 1 if .listbox1.Selected(i) then cells(rw,1).Value = .listbox1.List(i) rw = rw + 1 end if Next End with -- Regards, Tom Ogilvy "Francis Ang" wrote in message ... I have a listbox with with its properties set to mutliselect and is popupated with "Apples, Oranges, Peaches, Grapes, Apricot and Guava. When the user select say, Oranges and Grapes, I want these to be displayed but do not know how to write the code. I have looked at previous postings but the responses only dealt with showing the listindex value instead of the actual description. Can someone help! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiselect Listbox
Thank you very much Tom. Really appreciate your help.
"Tom Ogilvy" wrote: With Userform1 rw = 1 for i = 0 to .Listbox1.Listcount - 1 if .listbox1.Selected(i) then cells(rw,1).Value = .listbox1.List(i) rw = rw + 1 end if Next End with -- Regards, Tom Ogilvy "Francis Ang" wrote in message ... I have a listbox with with its properties set to mutliselect and is popupated with "Apples, Oranges, Peaches, Grapes, Apricot and Guava. When the user select say, Oranges and Grapes, I want these to be displayed but do not know how to write the code. I have looked at previous postings but the responses only dealt with showing the listindex value instead of the actual description. Can someone help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiselect Listbox use | Excel Discussion (Misc queries) | |||
Cannot dropitem from multiselect listbox | Excel Programming | |||
MultiSelect ListBox in Excel | Excel Programming | |||
Excel VBA-Looping though MultiSelect on ListBox | Excel Programming | |||
multiselect listbox | Excel Programming |