Combo Box Control-Multi?

[Steve]

I'm trying to use a combo box form control. One of the
control property options is "multi", meaning the user can
select more than one of the displayed choices. But if
you select this option, the link to the result cell no
longer functions since there would be more than one
result. How is this multi option used then? How do you
get the result in usable form instead of just a visual
highlight?
I'd appreciate any help available on this since it would
be a very useful function for my application.

 

[Tim Zych]

You're talking about a listbox, right?

Dim i As Integer
With ListBox1
For i = 0 To .ListCount - 1
If .Selected(i) = True Then
Debug.Print "Selected " & .List(i, 0)
End If
Next i
End With

For more info, see http://www.rubbershoe.com/listbox.htm

 

[Earl Kiosterud]

Steve,

The controls in the Control Toolbox are really meant to be handled by code,
though you can use them like the old Forms controls to some extent without
code with properties like cell links. So for multi-select, you need code to
check out the response(s), like that which Tim gave you.