Built-in for Selecting Ranges?

[jdawson]

Is there a way to call up those cool dialog boxes that Excel uses for users to select/enter a range into a text edit box?

Something like:

Application.Dialogs(xlDialogSelectRange).Show


Or, as an alternative, is it possible to continue displaying a userform while selecting cells on a worksheet, or selecting a new worksheet?

[Bob Phillips]

Yes, use the RefEdit control on a userform.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"jdawson" <[email protected]> wrote in
message news:[email protected]...
>
> Is there a way to call up those cool dialog boxes that Excel uses for
> users to select/enter a range into a text edit box?
>
> Something like:
>
> Application.Dialogs(xlDialogSelectRange).Show
>
>
> Or, as an alternative, is it possible to continue displaying a userform
> while selecting cells on a worksheet, or selecting a new worksheet?
>
>
> --
> jdawson
> ------------------------------------------------------------------------
> jdawson's Profile:
http://www.excelforum.com/member.php...o&userid=32198
> View this thread: http://www.excelforum.com/showthread...hreadid=519464
>

[Tom Ogilvy]

Look at the RefEdit control. If it isn't on the control toolbox toolbar,
try Tools=>Additional Controls

--
Regards,
Tom Ogilvy


"jdawson" <[email protected]> wrote in
message news:[email protected]...
>
> Is there a way to call up those cool dialog boxes that Excel uses for
> users to select/enter a range into a text edit box?
>
> Something like:
>
> Application.Dialogs(xlDialogSelectRange).Show
>
>
> Or, as an alternative, is it possible to continue displaying a userform
> while selecting cells on a worksheet, or selecting a new worksheet?
>
>
> --
> jdawson
> ------------------------------------------------------------------------
> jdawson's Profile:
http://www.excelforum.com/member.php...o&userid=32198
> View this thread: http://www.excelforum.com/showthread...hreadid=519464
>