title: Excel VBA InputBox Range Selection Button
body: <p>Ok. So I'm familiar with InputBoxs in VBA to some degree. I'm aware of the <code>Type:=8</code> requirement to select a range. My code works fine and allows me to do what I want to. </p>
  
  <p>This is what it looks like:
  <img src="https://i.stack.imgur.com/6NYvy.png" alt="enter image description here"></p>
  
  <p>However, I want to generate the same type of inputbox that Exel itself generates when selecting a range.</p>
  
  <p><img src="https://i.stack.imgur.com/TGpwS.png" alt="enter image description here"></p>
  
  <p>I've been searching through various online resources and the only thing that comes up again and again is that <code>Type:=8</code> needs to be used. The MS Help has also not been of much help.</p>
  
  <p>For completness' sake here is my code:</p>
  
  <pre><code>Dim SelRng1 As Range
  Dim SelRng2 As Range
  
  Set SelRng1 = Application.InputBox(Prompt:="Please select the first table (headers included)", Title:="Select Table 1", Type:=8)
  Set SelRng2 = Application.InputBox(Prompt:="Please select the second table (headers included)", Title:="Select Table 1", Type:=8)
  </code></pre>
  
  <p>Anyone know how to do this? Thanks!</p>