Urgent! Get User Entry (RANGE) from a DIFFERENT workbook

Cheers all!

Please help me on this one.

I'm trying to get a RANGE as an entry from the user.

The range is located in a different workbook than the one where the code is running.

So, the user sees a pop-up and is prompted to select a range.
She should be able to SWITCH TO ANOTHER WORKBOOK and select the proper range.

I've tried with the following, but failed:
- Application.InputBox Method
- RefEdit Control on a UserForm
Neither allows the user to select a range IN A DIFFERENT WORKBOOK.

How could this work?

Many thanks for your time,
Alex

Somebody?
Any feedback?
Please?

I'm trying to get a RANGE as an entry from the user.

The range is located in a different workbook than the one where the code is running.

So, the user sees a pop-up and is prompted to select a range.
She should be able to SWITCH TO ANOTHER WORKBOOK and select the proper range.

I've tried with the following, but failed:
- Application.InputBox Method
- RefEdit Control on a UserForm
Neither allows the user to select a range IN A DIFFERENT WORKBOOK.

How could this work?

Many thanks for your time,
Alex