RefEdit on Userform to pick up range in another workbook

[jase]

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

 

[Tom Ogilvy]

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