title: vba let user select a range on worksheet from ms access
body: <p>The sub RangeSelectionPrompt below let the user to select a range of cells.
  The code below works only if this code is on Excel files.</p>
  
  <p>I would like to know to execute this code inside of MSAccess. I want to capture the user selected range and do data manipulation.
  Is it Possible or  did I smoke to much.</p>
  
  <p>From Access I know how to lunch Excel, detect how many WBK are open, navigate in the workbook,.... 
  Form Excel I know how to create an add-in , connect to a DB and transfer the data after user selection but this is not what I want.</p>
  
  <pre><code>Sub RangeSelectionPrompt()
      Dim rng As Range
      Set rng = Application.InputBox("Select a range", "Obtain Range Object", Type:=8)
  
      MsgBox "The cells selected were " &amp; rng.Address
  End Sub
  </code></pre>