Looking for the replacement of RefEdit control
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
|