title: How to pass the button text dynamically to a vba function
body: <p>How to pass the button text dynamically to a vba function ?
  E.g, I have a button with text ''</p>
  
  <pre><code>Sub Status()
     Dim ButtonText As String
      With ActiveSheet.UsedRange
              .AutoFilter 3, "=&lt;button-text&gt;"
      End With
  End Sub
  </code></pre>