View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tushar Mehta Tushar Mehta is offline
external usenet poster
 
Posts: 1,071
Default range picker / selector

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?