RefEdit - cannot select range on another workbook
I have created a Userform in VBA with a RefEdit control.
I want to select a range in another workbook, but this does not seem possible. Any ideas? |
RefEdit - cannot select range on another workbook
Rob -
You can use Ctrl-Tab to switch among workbooks with the form open. Alternatively, you could populate a list box or combo box with the names of the open workbooks, and let the user switch workbooks this way. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Rob wrote: I have created a Userform in VBA with a RefEdit control. I want to select a range in another workbook, but this does not seem possible. Any ideas? |
All times are GMT +1. The time now is 09:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com