Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Built-in for Selecting Ranges?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Built-in for Selecting Ranges?
Yes, use the RefEdit control on a userform.
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "jdawson" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Built-in for Selecting Ranges?
Look at the RefEdit control. If it isn't on the control toolbox toolbar,
try Tools=Additional Controls -- Regards, Tom Ogilvy "jdawson" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting Ranges | Excel Programming | |||
Selecting ranges | Excel Programming | |||
V.B selecting ranges for naming | Excel Programming | |||
Selecting ranges with a text box | Excel Programming | |||
selecting ranges | Excel Programming |