With the control RefEdit in a userform I can select a range within th
same workbook as where the RefEdit is. How do I choose a range i
another workbook? I´m going crazy on this... :confused

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

Not sure if this helps but I use this to reference a listbox to another
file:

SysList.RowSource = Workbooks("System.tbl").Worksheets("System"). _
Range("A2:A" & RowCount).Address(External:=True)

Mike F
"pbengtss " wrote in message
...
With the control RefEdit in a userform I can select a range within the
same workbook as where the RefEdit is. How do I choose a range in
another workbook? I´m going crazy on this...


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

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

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

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/

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/