RefEdit on Userform to pick up range in another workbook

Not possible to use a RefEdit control on a modeless userform, and
"application.inputbox type:=8" is modal.

..........so how do I make a userform (within an add-in) that is going
to accept ranges from two different workbooks: it's got to be user
friendly! - that's why i was hoping to use the refEdit control

(the built-in RefEdit controls in Excel can go between workbooks no
problem - or are they different controls?)

Any help greatly appreciated

Jason

Use
set rng = Application.InputBox( type:=8)

--
Regards,
Tom Ogilvy



"jase" <biggest.ears@talk21.com> wrote in message
news:1117725813.747815.37230@g44g2000cwa.googlegroups.com...
> Not possible to use a RefEdit control on a modeless userform, and
> "application.inputbox type:=8" is modal.
>
> .........so how do I make a userform (within an add-in) that is going
> to accept ranges from two different workbooks: it's got to be user
> friendly! - that's why i was hoping to use the refEdit control
>
> (the built-in RefEdit controls in Excel can go between workbooks no
> problem - or are they different controls?)
>
> Any help greatly appreciated
>
> Jason
>