Select multiple values
Hello.
Use the Multiselect property of the listbox.
To retrieve the selected items, use (case of a worksheet listbox :
With Sheet1.ListBox1
For i = 0 To .ListCount - 1
If .Selected(i) Then
'code
End If
Next i
End With
HTH
Daniel
Hello all,
I'm trying to see if it's possible to create a list box where I can select
multiple values. For example, if a create a list box with the values, "ant",
"dog", and "cat". Is it possible for me to give the user the option to
choose, "ant" and "cat"?
Thanks in advance.
|