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

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