Thread: RefEdit - cannot select range on another workbook
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier[_4_] Jon Peltier[_4_] is offline
external usenet poster
  
Posts: 90
Default 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?

Reply With QuoteReply With Quote