Non-Modal InputBox?

  • Thread starter Thread starter NooK
  • Start date Start date
N

NooK

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
 
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
 
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
 
Well no, but you can't use that approach manually in the same/similar
circumstances.
 
Back
Top