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