Hi,

I am looking for the replacement of RefEdit which is using by Excel for its
worksheet functions. The RefEdit comes with Excel 2000 doesn't allow to
select any sheet in other workbook.

Thank you for any information.

Jerry

There is not replacement for the refedit control

You can get similar functionality by using

set rng = Application.Inputbox("prompt",type:=8)

see help on Application.Inputbox (rather than the vba inputbox).

--
Regards,
Tom Ogilvy

"Jerry Louis" wrote in message
...
Hi,

I am looking for the replacement of RefEdit which is using by Excel for
its
worksheet functions. The RefEdit comes with Excel 2000 doesn't allow to
select any sheet in other workbook.

Thank you for any information.

Jerry

Thanks Tom.

Even it cannot work as the Excel counterpart, it works better than RefEdit
when people need select a range in a different workbook. It also check the
validation of the inputed range.

"Tom Ogilvy" wrote in message
...
There is not replacement for the refedit control

You can get similar functionality by using

set rng = Application.Inputbox("prompt",type:=8)

see help on Application.Inputbox (rather than the vba inputbox).

--
Regards,
Tom Ogilvy

"Jerry Louis" wrote in message
...
Hi,

I am looking for the replacement of RefEdit which is using by Excel for
its
worksheet functions. The RefEdit comes with Excel 2000 doesn't allow to
select any sheet in other workbook.

Thank you for any information.

Jerry