title: Set any range with userform
body: <p>I am currently looking for a way to assign a range via UserForm. I've often encountered the example with the RefEdit, which unfortunately does not fit 100% to my problem.</p>
  
  <p>Is there a way where the enduser can assigns a range with a textbox? The User should be asked in which column in his sheet the relevant numerical values are and on that basis, the macro should adjust the range. </p>
  
  <p>For example: 
  The user types the range is in column H and there for the macro adjust to: </p>
  
  <pre><code>ws.Range("H2: H" &amp; lastrow)
  </code></pre>