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