Displaying the range picker dialog

[d_farquhar]

Hi all

First post here, very useful forum!

Basically, I'm controlling a group of Excel workbooks from an externa
application and need to be able to allow the user to grab various cell
references within the workbooks.

Does anyone know how to display the range picker dialog from VB code
It's the dialog that appears when for example, you use the 'Inser
Function' wizard and you click on the icon that allows you to enter th
field's cell reference. It's used in a lot of places within Excel s
I'm guessing it's a fairly common thing to use!

Is it part of the Built in Dialogs?

Cheers

Dann

 

[Kalle]

there is no build-in dialog "Range Picker" you can use.
this part of formulabuilder.

See Help for all constants you can use with
Application.Dialogs("xxxxxxx").show

 

[Tom Ogilvy]

It is the refedit control used on a userform.

you can also use the Excel inputbox

Dim rng as Range
On Error Resume Next
set rng = Application.InputBox( "Pick a range with the mouse", type:=8)
On Error goto 0
if rng is nothing then
msgbox "you hit cancel"
exit sub
End if

msgbox "range selected is " & rng.Address

 

[d_farquhar]

Cheers Tom, that does exactly what I require!

Dann