range picker / selector

[KT]

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?

 

[Guest]

Not that I am aware of.

 

[OJ]

Yes there is. It is called Refedit and it is available on the VBA Forms
toolbar..

Hth,
OJ

 

[Tushar Mehta]

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

 

[Guest]

Learn something everyday. Great

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

 

[Bob Phillips]

be careful though, it can take a bit of care as to where and how to use it.
For instance, never put it in a frame.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Tushar Mehta]

I've read many such claims about problems with the RefEdit control --
too many to ignore. So, yes, the OP should be careful.

Nonetheless, I have used Refedits quite successfully through the years.
The only problem I've had with it has been in modeless userforms (and
COM Add-ins); both problems/limitations are documented in the MS KB.
There are other documented problems with refedit. For more search
support.microsoft.com for 'refedit' (w/o the quotes).

Someone recently told me about the problem with a frame (and a multi-
page). I've also read problems attributed to multiple refedits on the
same form and refedits that overlap other controls. However, I've been
using refedits in a frame for years and have tested the other problem
scenarios along the way but have been unable to reproduce the problem.

One guess -- and this is strictly speculative -- is the use of RefEdit
event procedures (or event procedures that affect a refedit control).
Until working out a way to use refedits in modeless userforms, I have
never used a refedit_xxx procedure (haven't seen any value to one). It
would be interesting to see if the use of such procedures can be linked
to the reported problems.

Bottom line: just because I've been unable to reproduce reported
problems with it doesn't mean it is 100% safe to use. Just that I have
been happy with it.

--
Regards,

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