Help: Looking for the replacement of RefEdit control

[Jerry Louis]

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

 

[Tom Ogilvy]

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).

 

[Jerry Louis]

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.