title: VBA cannot get the property of the button you just clicked
body: <p>Now I have several buttons in the worksheet, each has set their captions. I want to implement a feature like this: when I clicked the button, a macro is executed to filter a specific row with the caption of itself, so I need to get the property, namely the caption,of the button I just clicked in the inner of the macro. </p>
  
  <p>My pseudo-code like this:</p>
  
  <pre><code>Sub filterPM()
      Dim capBt as String
      'get button caption as capBt
      ActiveSheet.Range(...).Autofilter(...,criterial=capBt,...)
  End Sub
  </code></pre>
  
  <p>I happened to find one solution is to use <code>Application.Caller</code>, but I cannot get the proper caption from it, the object returns the default caption which is like <code>button134</code> but not the caption I set when I created the button.</p>
  
  <p>So how can I make this?</p>