clear list box

[madrav72]

hi

can someone state how to clear a list box

thanks

 

[KenHigg]

What do you mean 'Clear'? Do you mean 'Un-Select' everything or remove the available selections completly?

 

[Mile-O]

To remove all options:

Me.MyListBox.RowSource = vbNullString

To deselect all options:

Dim varItem As Variant
    
For Each varItem In Me.lstExample.ItemsSelected
    Me.MyListBBox.ItemsSelected(varItem) = False
Next

 

[kousotsu]

Or to deselect all, just set me.myListBox.Value = Null