Multiselect List Box
Bill,
You could use the Listbox's change event to set a flag, but you won't be able to tell if an item is
selected and then de-selected, just that an item was (at some time) selected.
HTH,
Bernie
MS Excel MVP
"Bill" wrote in message
ink.net...
Hello All,
I have a list box that I populate using the following code:
Load Userform1
Userform1.varinclude.Clear
For i = 1 To NV
Userform1.varinclude.AddItem VarNames(i)
Next i
I know I can use "selected" to determine what has been selected in the list box. Is there a quick
way of telling if nothing has been selected? I can set of for loop to see if each selected is
false, but though there might be a quicker way.
Thanks.
|