Actually, you could do it if you don't mind a little extra coding. Put a listbox near the
control, populated with the names of the open workbooks. When one is selected, activate the
corresponding workbook under the form.

You're not using that RefEdit on a modeless form, are you? Good, because if you do, Excel will
hang in some rather amazing ways.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Jon Peltier wrote:

I though I knew how to do this, but the Window menu is inaccessible, and
Ctrl+Tab doesn't work.

Application.InputBox(Type:=8) provides very similar functionality, but
it allows you to navigate via the Window menu, and it's much less goofy
than the RefEdit.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

pbengtss < wrote:

Well, I want to be able to select any range in any workbook and have the
range returned automatically, just like the RefEdit-type controls in the
Chart dialog where you select the data ranges.


---
Message posted from http://www.ExcelForum.com/