View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default 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.