| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a control to pick worksheet cell ranges
I am building a form in Excel and need to select ranges. In my list of
available controls, I do not see the control that allows a user to select a range of cells (see the graph wizard for an excellent example). How can I add this conrol to my form? Thank you, Keith |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need a control to pick worksheet cell ranges
The control you want is called RefEdit. On the Forms toolbox,
right-click and choose Additional Controls. Find RefEdit in the list and select it to add it to the toolbox. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Sat, 11 Apr 2009 08:07:01 -0700, keith wrote: I am building a form in Excel and need to select ranges. In my list of available controls, I do not see the control that allows a user to select a range of cells (see the graph wizard for an excellent example). How can I add this conrol to my form? Thank you, Keith |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need a control to pick worksheet cell ranges
Hi Chip,
Thanks very much. keith "Chip Pearson" wrote: The control you want is called RefEdit. On the Forms toolbox, right-click and choose Additional Controls. Find RefEdit in the list and select it to add it to the toolbox. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Sat, 11 Apr 2009 08:07:01 -0700, keith wrote: I am building a form in Excel and need to select ranges. In my list of available controls, I do not see the control that allows a user to select a range of cells (see the graph wizard for an excellent example). How can I add this conrol to my form? Thank you, Keith |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I force entry in multiple cell ranges in one worksheet | Excel Worksheet Functions | |||
| How to get buttons on floating control to pick up colour | Excel Programming | |||
| How cell ranges are handled by worksheet functions/row column matc | Excel Worksheet Functions | |||
| How cell ranges are handled by worksheet functions/row column matc | Excel Programming | |||
| Creating a worksheet with values based on a control cell | Excel Programming | |||
Linear Mode
