ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   list boxes (https://www.excelbanter.com/excel-programming/318226-list-boxes.html)

hdodson

list boxes
 
does anyone know how to use the multi and extend features of the list box form



Tom Ogilvy

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





hdodson

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






Tom Ogilvy

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









All times are GMT +1. The time now is 02:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com