How to call the Excel "range-selection tool"?

**geophysicist** · 08-17-2013, 12:49 PM

In numerous GUI's within Excel (for example, when using the fx formula GUI), there is a selection tool that enables the user to graphically select a range of cells. The icon is a spreadsheet with a red arrow, highlighting the first cell. I don't know Excel's proper name for it, but I'd call it a "range-selection tool". Do you know how to call this tool from VBA?

Thanks,
g

**AlphaFrog** · 08-17-2013, 01:23 PM

Here's one way. It's not the same range selection tool you described.

Sub Select_Range_Prompt()
    Dim rng As Range
    On Error Resume Next
    Set rng = Application.InputBox("Select a range. ", "Range Selection", Type:=8)
    On Error GoTo 0
    If rng Is Nothing Then Exit Sub 'User canceled
    
    'Do something with rng
    MsgBox rng.Address(0, 0), , "Example"
    
End Sub