Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
range picker / selector
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
range picker / selector
Not that I am aware of.
"KT" wrote: 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
range picker / selector
Yes there is. It is called Refedit and it is available on the VBA Forms
toolbar.. Hth, OJ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
range picker / selector
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? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
range picker / selector
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" wrote in message om... 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? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
range picker / selector
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 In article , says... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selector disappears | Excel Discussion (Misc queries) | |||
Multiple product selector | Excel Worksheet Functions | |||
Equation Selector | Excel Discussion (Misc queries) | |||
selector | Excel Worksheet Functions | |||
selector | Excel Worksheet Functions |