View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Forms, Range Control

It is called the RefEdit tool. Right-click the controls toolbox, and select
additional controls, and scroll down and select it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Eric" wrote in message
...
I am running Office 2003, on a XP Pro OS.

I am trying to build a form in VBA for Excel and want to allow the user to
select a range similar to how the chart dialog works. The control is
basically a text box, but it has the little spreadsheet looking button

that
allows the user to select a range from the spreadsheet. Are these

available
on forms, and how to I get it to appear in the Forms Tool Bar?

Thanks much, in advance.

Eric