Need a control to pick worksheet cell ranges

[keith]

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

 

[Chip Pearson]

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)

 

[keith]

Hi Chip,
Thanks very much.
keith

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)