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/