Learn something everyday. Great

"Tushar Mehta" wrote:

It's called the RefEdit control. However, it may not be on the
userform controls toolbar. Right click the toolbar, select Additional
Controls... and scroll, locate, and select the RefEdit.Ctrl control.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
There are a couple of dialog boxes in Excel that has a
little icon to the right of where a range parameter is
required. This icon collapses the rest of the dialog box
and brings the activesheet to focus allowing the user to
select a range using the mouse (instead of typing it in).

Question: Is this a standard control I can access and use
on my own forms?