How to add "Select Data Source" to my Excel appliation?

Question

I need the "Select Data Source" dialog added to my application so that the user can manually select a range (or ranges) in Excel and the range is pasted in my text box. This functionality is everywhere in Excel (most notably when selecting a range for a chart). How can I easily do this?

Answer 1

have you tried using the refedit control?

How to Use the RefEdit Control with a UserForm

Answer 2

Dim myRange As Range
  On Error Resume Next
  Set myRange = Application.InputBox(prompt:="Select the cells you want", Type:=8)
  On Error GoTo 0
  If myRange Is Nothing Then
    MsgBox "User cancelled"
  Else
    MsgBox "User selected " & myRange.Address
  End If

This will show an input dialog. Don't type anything into it, but instead, select cells with the mouse, and their address will appear in the dialog textbox. When you press OK,they should be assigned to the variable myRange.

Notes: The "Type:=8" at the end of the InputBox line tells VBA this must be a range of cells The On Error bit prevents an error if the user cancels

Answer 3

We found this, which looks like it may be perfect (.NET compatible):

HOW TO CODE A .NET REFEDIT CONTROL