Clear selections of listbox?

[RON]

I have a listbox lstSelected I have selected a couple entries in the
listbox, however I want to add a button that when clicked will clear the
selections off of the listbox and nothing will be selected....How would I do
this?

 

[Duane Hookom]

Try
Me.lstSelected.RowSource = Me.lstSelected.RowSource

 

[Allen Browne]

Duane, that's a clever concept, but I don't think it works for all cases. In
the example I tried, the list box was unbound, single column (no hidden
column), not multi-select, with a simple SQL statement as RowSource.

The code I use to clear the list is here:
http://allenbrowne.com/func-12.html
and should work whether the list box is multi-select or not.

 

[Duane Hookom]

Thanks Allen. I was just working on a project with simple multiple select so
the code was copied and pasted in the reply. I am adding your functions to
my framework.