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

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

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