Clear ListBox

[bt2086]

In a userform, I have a listbox and several different option buttons that are associated with the listbox. How do I clear the list box everytime I click on different option button?

The problem that I have right now is that as soon as i click on the second option button, it takes the value from the 1st option button in addition to the second option button's value.

Thanks!

 

[mikerickson]

If you want to remove all the items from the Listbox's list

ListBox1.Clear

If you want to de-select the listbox's selection, leaving the items in the box, available to be selected again

ListBox1.ListIndex = -1

You could put the appropriate line in each of the option buttons' Change event.