You should be able to select from any open workbook using the inputbox. On
way is to go to the Window menu and select the workbook from there.

If your workbooks are not maximized, then you should be able to navigate to
them directly using the mouse. Works fine for me.

Sub BBBB()
Dim rng As Range
On Error Resume Next
Set rng = Application.InputBox("select range", Type:=8)
Debug.Print rng.Address(external:=True)
On Error GoTo 0
End Sub


--
Regards,
Tom Ogilvy


"NooK " wrote in message
...
I am having a small problem,

I have a inputbox which is set to Type 8 (Returns a Range type) and the
selection will be set to a listbox rowSource.

My problem is that the user needs to be able to select the Range from
any of the Open Workbooks and apparently I can't choose any other book
than the one I am running the Macro from, which I believe it has to do
with the InputBox being Modal.

Is there anyway to make the inputBox Non-Modal, or a way around it?

Best Regards

NooK


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