View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default 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