Help: Looking for the replacement of RefEdit control
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 |
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 |
Looking for the replacement of RefEdit control
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 |
All times are GMT +1. The time now is 05:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com