title: How to get selected text in VBA
body: <p>I have a macro that changes the selected text, and I have it assigned to a button.</p>
  
  <p>It works perfectly when i run it directly from visual basic, but when I click the button, the button gets the focus and my text is no longer selected so the macro change the selected element to (button).</p>
  
  <p>How can I select the text and run the macro by clicking on the button and still have the text selected?</p>