title: How to select radio button with vba excel vba
body: <p>I have 6 option buttons (form control). They are used for searching columns on a table below on the same worksheet. I have a basic search bar. I'd like to create a RESET button where it will reset the column filters and select a specific/default option button. These buttons are (Form Control) because the code I use for the search Macro was only working that way.</p>
  
  <pre><code>Private Sub cmd_RESET_BASIC_Click()
  'PURPOSE: MANUAL FILTER RESET
  
  ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=2
  ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=4
  ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=5
  ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=8
  ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=25
  ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=24
  ActiveSheet.Shapes.Range(Array("Option Button 5")).Select
  
  End Sub
  </code></pre>
  
  <p>I tried Recording a macro since I am new.</p>
  
  <p>How can I Select Option Button 5 and make it true and having the others false?</p>