I am having a small problem,

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

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

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

Best Regards

Noo

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

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/

OK Using the windows menu did work (Thanks for that) but I cannot choos
a workbook by clicking on the minimized icon on the task bar.

I click on it, it chooses it but the background workbook is still th
first one.

Best Regards

Noo

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

Well no, but you can't use that approach manually in the same/similar
circumstances.

--
Regards,
Tom Ogilvy

"NooK " wrote in message
...
OK Using the windows menu did work (Thanks for that) but I cannot choose
a workbook by clicking on the minimized icon on the task bar.

I click on it, it chooses it but the background workbook is still the
first one.

Best Regards

NooK


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