Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
list boxes
does anyone know how to use the multi and extend features of the list box form
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
list boxes
See the help on this feature. It explains it.
-- Regards, Tom Ogilvy "hdodson" wrote in message ... does anyone know how to use the multi and extend features of the list box form |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
list boxes
Tom
thanks for the respose but i have read the help and didn't quite understand it. I want the list box to return the list or a value if multiple items are selected. dodson "Tom Ogilvy" wrote: See the help on this feature. It explains it. -- Regards, Tom Ogilvy "hdodson" wrote in message ... does anyone know how to use the multi and extend features of the list box form |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
list boxes
msg = ""
With listbox1 for i = 0 to .listcount-1 if .selected(i) then msg = msg & "Item " & i & " value: " & .list(i) & _ " is selected" & vbNewline end if Next End with msgbox msg -- Regards, Tom Ogilvy "hdodson" wrote in message ... Tom thanks for the respose but i have read the help and didn't quite understand it. I want the list box to return the list or a value if multiple items are selected. dodson "Tom Ogilvy" wrote: See the help on this feature. It explains it. -- Regards, Tom Ogilvy "hdodson" wrote in message ... does anyone know how to use the multi and extend features of the list box form |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
Questions on combo boxes and list boxes. | New Users to Excel | |||
list boxes | Excel Discussion (Misc queries) | |||
List boxes | Excel Programming | |||
List boxes/combo boxes | Excel Programming |