Need a control to pick worksheet cell ranges

  • Thread starter Thread starter keith
  • Start date Start date
K

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
 
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)
 
Hi Chip,
Thanks very much.
keith

Chip Pearson said:
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)
Click to expand...
 
Back
Top