title: VBA Excel Toggle Button "Latching"
body: <p>I have the following code corresponding to three ToggleButtons in a VBA Program in Excel. When one button is clicked, it is supposed to stay "pressed" and the other two buttons are supposed to "release". However, with the code I have, I have to click on one button TWICE, once to release the other buttons and the other to keep the original one pressed. </p>
  
  <p>However, if I add "ToggleButtonX.Value = True" to each of the Subs, when one button is clicked, it cannot release even after clicking another button. How could one configure this so that when one clicks on one button, that button stays pressed AND the other buttons get released? </p>
  
  <p>EDIT: I would like to KEEP TOGGLEBUTTONS. </p>
  
  <pre><code>Private Sub ToggleButton1_Click()
      ToggleButton2.Value = False
      ToggleButton3.Value = False
  End Sub
  
  Private Sub ToggleButton2_Click()
      ToggleButton1.Value = False
      ToggleButton3.Value = False
  End Sub
  
  Private Sub ToggleButton3_Click()
      ToggleButton1.Value = False
      ToggleButton2.Value = False
  End Sub
  </code></pre>