title: Making List Box items work like option buttons VBA
body: <p>I have a VBA user form with a list box that contains 8 items. Its defined as a multi-select listbox.
  Item 2 and item 3 are dependent on each other so they can't both be selected together.
  In order to do that I wrote:</p>
  
  <pre><code>If ListBox1.Selected(3) = True Then
      ListBox1.Selected(2) = False
  ElseIf ListBox1.Selected(2) = True Then
      ListBox1.Selected(3) = False
  End If
  </code></pre>
  
  <p>It does work but not very nicely. If I choose item 2 and than item 3 its fine. but if I try to choose item 2 afterwards than I need to unselect item 3 first and than choose item 2. Is there a better way to do that so it may work like option buttons without the need to cancel the selected item before selecting another?</p>